Moonbeam
Blogger
Share this content
0
9
5174

quickbooks report options for Excel output

quickbooks report options for Excel output

I am going to see a client on Monday who is using quickbooks. I am prepared for there to be loads of errors, and have already agreed that if I sort this out I will be using Sage, not QB. I am guessing they are using one of the bigger desktop packages. I would download the data initially to excel to see what the errors might be.

Can a kind person please tell me how to get: a bank reconciliation report, a TB, a list of all transactions in nominal, purchase and sales ledgers? Is there an audit trail report? How do I get VAT reports for each VAT period? I intend to download these to excel, and believe there is a csv report option as well as pdf.

Thank you in advance for your patience!

Replies

Please login or register to join the discussion.

15th Jun 2012 23:39

Not the answer you want...

... but, why not work on the file in Quickbooks? If that's what your client wants to use (and it is easy to use), then why not?

Thanks (0)
avatar
16th Jun 2012 09:34

Under company select chart of accounts/reports/reports on all accounts/other

 

Under which you select trial balance and General ledger (nominal ledger)

 

any of these reports you can then print as they are or export to Excel.

 

As for Sales ledger go to reports  and select customers and receivables (for the sales ledger) and  then suppliers and payables for the purchase ledger reports.

 

Personally I agree with James, we use both quickbooks and sage, and i think quickbooks is much easier to use, and much easier as regards reporting,  so I'd save a heap of time if I were you and post the adjustments in quickbooks.

 

If you spend about 5 mins with quickbooks you'll be able to use it to the full,  I think you'll be quite impressed,  its very intuitive to use.

Thanks (2)
16th Jun 2012 11:00

Accountants copy

Use the same version of Quickbooks as the client (borrow their disc), take an accountant's copy at the year-end, make your adjustments in Quickbooks and then use the final file for their accounts and to re-import into their Quickbooks.

Thanks (1)
16th Jun 2012 15:17

Thank you!

Thanks for spending your weekend looking after me!

Thanks (0)
16th Jun 2012 18:21

Easier to export all reports to an Excel workbook

Hi Moonbeam - here's a sheet we send our clients who use QBs.  I've added the Audit Report and Bank rec options.

Given the General Ledger print give you a full nominal history, I never bother with the Audit Trail.

Hope that helps

Thanks (1)
16th Jun 2012 19:57

QuickBooks is so easy

"Can a kind person please tell me how to get: a bank reconciliation report, a TB, a list of all transactions in nominal, purchase and sales ledgers? Is there an audit trail report? How do I get VAT reports for each VAT period? I intend to download these to excel, and believe there is a csv report option as well as pdf."

Go to Reports and you will find all the reports you want.

There may be an audit trail. It depends if the client has chosen to have one.

It's a pity that you are planning to use Excel and Sage. QuickBooks makes it very easy to review the double entry and make corrections. You can drill down from the reports to individual data entry forms.

If you stick with QuickBooks you don't need to mess about with an accountants copy if your client is not going to make entries while you correct transactions.

Thanks (1)
16th Jun 2012 20:47

Sage?
Stand-by to lose your client if you expose them to the useability horrors of Sage after using QB.
Instead, why not spend the time on getting them to use QB properly (skills necessary for them to use any accounting system properly). Surely If they don't know what they are doing imposing Sage on them won't fix anything.

Captain

Thanks (1)
16th Jun 2012 21:53

Thank you, thank you, Thank you!!!

Thank you all for the work you've put in for me here.

My renewal of Sage Line50 is due in a few days. As usual they haven't had the courtesy to tell me how much, and I will have to chase them to find out what exciting increase they are imposing this year. I have to use that as most of my clients use it and I train on it.

I am an expert user on Sage as far as the book-keeping side is concerned, and the sorting out that I am going to have to do will (I am guessing) involve sorting the QB basic input in Excel to see how well it's been done (badly I assume) and then re-sorting and importing the kosher stuff into Sage, adding all the things that I guess won't have been input. That is the speediest way for me, but I would use the same method if the original input had been in Sage assuming things are as bad as I think they will be.

It is early days and until I have seen the data I won't be able to make a recommendation to the client.

Quick books multicompany is going to be a similar cost to Sage if I buy that. I took an executive decision long ago that I will only spend so much time and money buying/learning a particular form of software. I have taken on VT and that is dead easy. The idea of logging on remotely to a client's pc (which will probably run slowly and be destined for the knackers yard) is not workable for me for large chunks of input.

Should I run out of clients using Sage or VT I will revise my options. Sage is only unusable if the user hasn't been trained properly. As training is one of my specialities I can assure you my trainees produce very high standards of input using Sage and I find it easy to use myself.

 

Thanks (0)
avatar
23rd Jan 2013 19:51

Time for a review ?

Everyone said stick with QB.

Absolutely. 

QB: Drill on transaction, change it, save it.

Sage: Get transaction no, close everything down, go into maintenance, work out the transaction, do a journal, red ink.  Or has Sage changed? I'm keen to know.

Thanks (0)