more-arw search

Q&A Forum

Quickbooks Summary Aging Question

I have been asked to provide a summary look at our total AP, what is due in 25 days, and what is due in 45 days. In other software I would create an aging with an 'As Of' date that matched the 25 and 45 days letting me drop in the totals when produced. However, when I tried that with the program today, my totals changed. The current report had a total of $785K, and the other reports totaled $815K (rounded). We do not put payables in using future dates, so it isn't an item that doesn't exist as of today. Is there something I am overlooking? QB isn't my favorite program, but I need to find solutions to questions today, as opposed to waiting for our new ERP system to be ready.


Topic Expert
Christie Jahn
Title: CFO
Company: Prime Investments & Development
(CFO, Prime Investments & Development) |

Have you tried running the Aging detail to see if you can locate the discrepancy?

Julie Adelman
Title: Controller
Company: NuScale Power, LLC
(Controller, NuScale Power, LLC) |

I believe you need to make some adjustments in the "customize" menu. The AP reports default to aging from whatever day you are running the report (the "current date".) If you need to show the aging from, say, July 31, change "current" to "report date" in the customize menu and enter 7/31/2013 as your reporting date. Then change the aging days to 25. I hope this helps.

Ron Bowker
Title: 0
Company: Novotus
(0, Novotus) |

Sara, Julie is spot on in what you need to do to change the report settings. My settings always default to current date instead of report date, so I always have to remember to change it in the settings myself.

Jaime Campbell
Title: Chief Financial Officer
Company: Tier One Services, LLC
(Chief Financial Officer, Tier One Services, LLC) |

If I correctly understand your problem, you need to set it up in QB and then export to Excel.

I made a video for you showing you step-by-step how to produce your report in 5 minutes.The technique is also flexible, so you can change the buckets and the formulas will update automatically, and then you just have to refresh the PivotTable.

Kay Flanery
Title: Consultant
Company: JCS Computer Resource Corp.
LinkedIn Profile
(Consultant, JCS Computer Resource Corp.) |

QB Aging - yes, you can change the aging periods in preferences. Also, are you saying the total do NOT agree with the G/L account? If that is so, you have a different problem. I can help. Kay Flanery, 314.443.5678


Get Free Membership

By signing up, you will receive emails from Proformative regarding Proformative programs, events, community news and activity. You can withdraw your consent at any time. Contact Us.

Business Exchange

Browse the Business Exchange to find information, resources and peer reviews to help you select the right solution for your business.

Learn more

Contribute to Community

If you’re interested in learning more about contributing to your Proformative community, we have many ways for you to get involved. Please email [email protected] to learn more about becoming a speaker or contributing to the blogs/Q&A Forum.