Quickbooks question

[k3am]

I promise, I'm not a weird spam bot. 

For anyone familiar with quickbooks - how difficult is it for a company to generate historical aging reports on an invoice date basis? Ie - if I asked them to send me A/R and A/P aging reports for the past 12 months (ie: as of 1/31, 2/28, 3/31, etc) based on invoice date when they historically prepare due date, am I really making someone's life difficult?

[welly01]

Do you just need to know which invoices were outstanding at which dates? The aging report that shows the 30, 60, 90 day "buckets" cannot be changed from invoice due date to invoice date. But if you just need to know the amount outstanding for a vendor or customer at a certain date you can run a Vendor Balance Summary (for A/P). You can run it for any date period you like.

[k3am]

The 30, 60, 90 day buckets are fine. I just need the invoices grouped into buckets based on the date of issuance - ie: an invoice issued on 1/31/17 with n60 days to show up in the 30-60 column based on the date issued rather than in the current column based on the due date.

I know this possible since I have multiple clients (who shouldn't be) using Quickbooks and can get me the reporting.

[oldbaylover1024]

I know I'm late answering, but this isn't difficult. If it's the 30, 60, 90 day buckets, that's really easy. But you can sort by customer so each bucket is sorted by the customer or vendor.

Also, I would join a QuickBooks group on LinkedIn. It's a great sounding board for questions like this. Lots of QB experts are in those groups and can give you step-by-step instructions to pass on to the individual running the report.

[k3am]

oldbaylover1024, basically I just wanted to point out to one of my auditors that he was being a lazy asshole and making excuses. But wanted to confirm that was the case before I did it.