Results 1 to 4 of 4

Thread: Quick Books - need Ageing Drs/Crs Totals

  1. #1
    Diamond Member Justloadit's Avatar
    Join Date
    Nov 2010
    Location
    Johannesburg
    Posts
    2,671
    Thanks
    88
    Thanked 544 Times in 460 Posts
    Blog Entries
    1

    Quick Books - need Ageing Drs/Crs Totals

    I am using Quickbooks 2007, however I need some reports which I am having difficulty getting.

    What I wish to have is a Debtors, and a Creditors list - aged - note not outstanding amounts, actual totals accumulated for each month while trading. I can do the report, but it lists all the transactions, which I do not want, I just want the total for each debtor and each creditor aged.

    Can anyone point me in the right direction.
    Victor - Knowledge is a blessing or a curse, your current circumstances make you decide!
    Solar and LED lighting solutions - www.microsolve.co.za

  2. #2
    Site Caretaker Dave A's Avatar
    Join Date
    May 2006
    Location
    Durban, South Africa
    Posts
    20,980
    Thanks
    3,055
    Thanked 2,463 Times in 2,068 Posts
    Blog Entries
    12
    Use the custom summary report generator rather than custom transaction detail report generator. This should give you totals only for each field.
    The trouble with opportunity is it normally comes dressed up as work.

  3. Thanks given for this post:

    Justloadit (07-Mar-12)

  4. #3
    Diamond Member Justloadit's Avatar
    Join Date
    Nov 2010
    Location
    Johannesburg
    Posts
    2,671
    Thanks
    88
    Thanked 544 Times in 460 Posts
    Blog Entries
    1
    Thanks Dave, just what I am looking for.

    Phoned Quickbooks, and they wont support previous versions only the latest version, and then they want to charge R250 support, to answer this question.
    Victor - Knowledge is a blessing or a curse, your current circumstances make you decide!
    Solar and LED lighting solutions - www.microsolve.co.za

  5. #4
    Gold Member
    Join Date
    Mar 2012
    Location
    Vanderbijlpark
    Posts
    886
    Thanks
    83
    Thanked 381 Times in 298 Posts
    Quote Originally Posted by Justloadit View Post
    I am using Quickbooks 2007, however I need some reports which I am having difficulty getting.

    What I wish to have is a Debtors, and a Creditors list - aged - note not outstanding amounts, actual totals accumulated for each month while trading. I can do the report, but it lists all the transactions, which I do not want, I just want the total for each debtor and each creditor aged.

    Can anyone point me in the right direction.
    If you don't want outstanding amounts, then I assume you want the totals sold, per period, per debtor?
    If so, use Sales By Customer Summary. Set the date range the period you want. In the Columns dropdown change it from Total Only to Month.

  6. Thanks given for this post:

    Justloadit (09-Mar-12)

Similar Threads

  1. Quick Books - Currency Symbol
    By Justloadit in forum Accounting Forum
    Replies: 4
    Last Post: 09-Jun-11, 07:06 PM
  2. Quick Books - Customer Journals
    By KimH in forum Accounting Forum
    Replies: 17
    Last Post: 09-Jun-11, 05:46 AM
  3. Books about inventions
    By Muzix1 in forum Book Forum
    Replies: 2
    Last Post: 19-Nov-10, 10:22 AM
  4. Fiddling the books?
    By Dave A in forum Business Finance Forum
    Replies: 1
    Last Post: 08-Nov-09, 03:23 AM
  5. E-books?
    By RKS Computer Solutions in forum Administrative issues
    Replies: 4
    Last Post: 25-May-07, 12:10 PM

Tags for this Thread

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •