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.
Quickbooks Summary Aging Question
Answers
Have you tried running the Aging detail to see if you can locate the discrepancy?
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.
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.
If I correctly understand your problem, you need to set it up in QB and then export to
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.
http://screencast.com/t/0whWnGTH7Sn8
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