The Orders with Balance Due Report provides a way to see all sales orders in the system that have not been fully paid or that have been overpaid. Overpayments are displayed in parentheses. When you run the report, you can choose to include group sales reservations, as well as pay on arrival orders. If you select Include group sales reservations, you also have the option to include canceled reservations.

Additionally, you can exclude orders from this report based on date. To view only orders with a balance that were placed after a specific date, in the Exclude orders before field, select a date. To apply the filters and view the updated report, click View Report.

This report includes three sections depending on the options you have selected and the orders in your database.

The Reservations with deposit due section displays group sales orders that have not yet paid their deposit. If the deposit is past due, the number of days past due is displayed. Additionally, the order number, patron name, visit date, deposit due date, and deposit balance amount are displayed.

The Reservations with order balance due section displays group sales orders that have an unpaid balance or an overpayment. If the balance is past due, the number of days past due is displayed. Additionally, the order number, patron name, visit date, order balance due date, and balance amount are displayed.

The Pay on arrival orders section displays sales orders that where processed with the pay on arrival option and have an unpaid balance or an overpayment. The order number, patron name, order date, and balance amount are displayed.

To access the Orders with Balance Due Report navigate to Sales>Reports>Orders with Balance Due.

It is important to note that this report is dynamic and will not provide a historical view of orders with balances due. To use this report accurately to record journal entries, the report must be run either at the end of the day on the last day of the month, or first thing the morning of the first day of the following month. For example, David and Johnson Pharmaceuticals visited your establishment on March 22, 2012 and their order had a balance of $1,000 at June 30, 2014. This order will appear on the Orders with Balance Due report when it is run on June 30, 2014.
User-added image

On July 2, 2014 David and Johnson Pharmaceuticals pays their balance. If for whatever reason, I had not run the Orders with Balance Due report on June 30, 2014 at the end of the day or July 1, 2014 first thing before any activity is processed and I run it on July 5, 2014 this order will not appear on the report because on July 5, 2014 it is no longer a balance due.