Invoice Recap Statements

Summary

I bill my customers all month long, and at the end of the month I wrap up all invoices and they are to pay me for all these invoices by the 15th of the following month. No discounts. Some customers have interest on overdue accounts. I have some customers that don't pay. One such customer owes me for July and August and some invoices that are "current" billed in this month of Sept. I cannot get a statement to show "current". It's always blank. I need to print statements any day of the month I choose that will correctly show these terms on a statement. I've tried various ways to show "current", "1-30 days past due", and "31-60 days past due" with no luck. I won't bore you with all that I've tried (date driven +standard + with various due dates – before -after, within etc.) Would you show me how I can accomplish this in QuickBooks 99?

Question

I bill my customers all month long, and at the end of the month I wrap up all invoices and they are to pay me for all these invoices by the 15th of the following month. No discounts. Some customers have interest on overdue accounts. I have some customers that don't pay. One such customer owes me for July and August and some invoices that are "current" billed in this month of Sept. I cannot get a statement to show "current". It's always blank. I need to print statements any day of the month I choose that will correctly show these terms on a statement. I've tried various ways to show "current", "1-30 days past due", and "31-60 days past due" with no luck. I won't bore you with all that I've tried (date driven +standard + with various due dates – before -after, within etc.) Would you show me how I can accomplish this in QuickBooks 99?

Answer

If report preferences are set to show aging from the Due Date, the statements show aged receivables according to the following rules Current - The sum of all open invoices with a "Due Date" that is after the date of the statement. The Due Date calculates automatically on invoices when you set the terms. 1-30 - The sum of all open invoices with a "Due Date" that is between 1 and 30 days prior to the statement date. 31-60 - The sum of all open invoices with a "Due Date" that is between 31 and 60 days prior to the statement date. 61-90 - The sum of all open invoices with a "Due Date" that is between 61 and 90 days prior to the statement date. If report preferences are set to show aging from the transaction date, the ‘due date’ is ignored and can result in the above situation. This is because an invoice dated today becomes 1 day past due tomorrow regardless of the terms or the due date.