1. Home
  2. QuickBooks Discussions
  3. Tracking receivables / cashflow

Tracking receivables / cashflow

Hi -

We run a repair shop with a parts department. Lots of customers have open accounts with us. Our terms are Net 30. So at the end of May we print statements for May invoices, and the customers have till the end of June to pay. It's always defined by month. Everything from whatever month is due by the end of the next month.

From what I've seen, all the accounts receivable reports in 2005 Pro

are based on invoice date, not month. So a May 3rd invoice would be treated very differently than a May 28th, even though they are both due at the end of June. We resort to going through copies of all the statements that we mailed to get a feel for how much money is still coming in!

If today is June 15th and I want totals of unpaid invoices from before June 1st... what's the best way?

Thanks!

Reply to
jeremylavallee
Loading thread data ...

Assuming you enter a due date on your invoices, you can run your reports and sort or filter by due date.

Reply to
Lisa C

Guys - I think I've figured out my question. In 2005 Pro, if you run the A/R summary report and set the date as the end of the previous month, it will display unpaid invoices as of the end of the previous month. By eliminating the new month's invoices, you're also eliminating the recent payments.

However, > Hi -

Reply to
Jer

Seems I remember some preferences for aging to allow just what you want. Can't remember if they were for statement charges only or for invoices though. I know you can set up payment terms based on a date rather than a number of days. Perhaps that is what you are looking for?

Reply to
Golden California Girls

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.