Quickbooks reportng help needed

Quickbooks reportng help needed

Didn't find your answer?

I've set up a chart of accounts with a number of parent/child type relationships - e.g.: a parent P&L expense of Telephone and then sub accounts of landline, mobile, other, etc.

When I run the P&L it insists on showing me all of the child/sub accounts and sub totals whereas I want it to show the total of Telephone.  I need the sub accounts for detailed analysis, I certainly don't want them in the P&L on page one of a set of management accounts.

Quickbooks helpline tells me this can't be done but I can't believe that this is the case.  Surely the point of sub accounts is that you can choose what level to report at - account or sub account.

Any help will be gratefully received.

Replies (10)

Please login or register to join the discussion.

By Captainblack
21st Jan 2013 20:05

Press the collapse button
Have you tried the Collapse button?

Thanks (1)
By ChrisScullard
21st Jan 2013 23:21

Thanks Capn Black.  As I

Thanks Capn Black.  As I suspected there is a very straightforward solution.  If only the helpline knew about it.

Apparantly I was the first person who has ever asked about this!!!!

Thanks (0)
By Captainblack
22nd Jan 2013 07:29

Also try the export to Excel.

The standard reports in QB are very 'user tailorable', you just need to spend a few minutes trying the options really. Also, if you haven't done this already, open a report and hit EXPORT and send it to an Excel spreadsheet. It will open with all the sub-totals and totals having formulas (not just the figures) so this is also a very flexible way of creating analysis reports.

Creating customised (non-standard) reports is little more tricky but you can get there in the end.

Enjoy

Captain

Thanks (0)
avatar
By c.szpak
31st Jan 2013 11:31

QuickBooks Reports & Excel

Following on from captainblack's advice.  Once you have sent the report to Excel, if you want to update the report for a different period:

Open the excel file, I suggest you save it under a new name, locate the QuickBooks menu in excel (at the far end from "File") then "update report". It will prompt you for the required dates just enter and let QB and excel do their stuff!

I use this facility for a client where the management accounts pack, includes sheets for: actual to budget; actual to last year; statement of cash flows;payables; receivables; and more.  Saves a lot of time even though you have to do each sheet individually.

By the way I am using QuickBooks Premier 2012 and Excel 2010.

Good luck

Chris

 

Thanks (0)
Replying to davidwinch:
avatar
By duncanphilpstate
04th Feb 2013 11:26

Sounds like you need a macro?

"I use this facility for a client where the management accounts pack, includes sheets for: actual to budget; actual to last year; statement of cash flows;payables; receivables; and more.  Saves a lot of time even though you have to do each sheet individually."

Chris (C.Szpak) - If you are having to change the date(s) on each sheet individually, it sounds like you should be using a macro to sweep across them all.

PM me if you'd like further thoughts on how to do that.

Thanks (0)
By mydoghasfleas
31st Jan 2013 12:12

Some Quickbooks quirks with Excel

When you export to Excel, Quickbooks shows some US roots by putting the dates into MM/DD/YYYY format; it's no big deal to change the formatting but unless you realise it has done it, you might scratch your head.

Also, it does export formulae and uses the round function.  I think the round function is essential in any spreadsheet but dear old Intuit has decided to round to five decimal places as standard but to format currency to two decimal places. 

Probably the only current software designed when farthings were about http://en.wikipedia.org/wiki/Farthing_%28British_coin% for those of you whose childhood started later than 1960.  I'm off for my wam milk and Sanatogen, "Nurse, Nurse can you help me please?".

Thanks (0)
avatar
By c.szpak
31st Jan 2013 12:44

Date format

I acknowledge that QuickBooks did have the date format issue which was immensely frustrating.

However I am running both 2012 and 2013 versionsand all the dates come out in the format  dd/mm/yyyy.

 

Thanks (0)
By Captainblack
31st Jan 2013 12:48

Dates - were a minor problem in old versions ..

The date issue has been fixed for some while. I think it was OK in 2010 also.

Capt

Thanks (0)
By mydoghasfleas
31st Jan 2013 14:03

2010 version Mysterons

Thanks Captain.

I'm using 2010 but am still getting the issue.  I know I indicated I was old but I'm not running the software on a Babbage.  Still if you remember Captain Black we are both classic vintages.

Thanks (0)
avatar
By Gone Sailing
31st Jan 2013 19:03

QuickBooks Versions

QB2013 is very cheap on Amazon these days - one client picked it up for £60 on a lightening deal.

However - if you get the Accountants edition - some really neat reporting features and you can load files from previous versions.

Thanks (0)