Balance a DBR

How to Balance a DBR

When the total charges are equal to the total payments on the Daily Business Report (DBR), it is said to be in balance. If a DBR is not in balance, it must be corrected. Here are the steps to go through to get it in balance.

To watch a video on this topic, please click here: How to Balance a DBR. (Be sure to turn up your speakers!)

Isolate the area where imbalance occurs

If the DBR is being run for the month, try running it for a week at a time. If the imbalance can be isolated in one of those weeks, run the DBR for each day of that week. The imbalance may have occurred on just one of those days. Doing this will reduce the number of contracts that must be checked.

Do the total receipts match total of charges & deposits?

If the charges match the payments and applied deposits, the DBR is in balance. If not, make a note of the difference.

Finding the Imbalance

Can you find a single transaction or charge to match the balance differential? This is probably the transaction that is causing the imbalance. If more than one transaction is causing the imbalance, it may be more difficult to pinpoint. Since the sum of the out-of-balance transactions is involved in the differential, you will not see a single transaction amount matching the differential.

Compare all payments against closed contract amounts. Payments that do not match up with the contract amounts will cause an imbalance.

Check all split revenues to insure the amounts are correct.

In most cases, down at the bottom of the report under the totals summary, you will see a reconciliation section that let's you know what contract or contracts are causing the imbalance.

Fix the contract

Once you have located the problem contract, check the report dates on it:

• Go into Contract Modify and select the contract.

• Scroll to the right in the Charges Browser to see the report dates. Make sure the charges and payments that have the same report date are in balance.

• To modify the report date on miscellaneous charges, taxes or payments, click on the DBR button .

• To modify the report date on a specific payment, go to the Charges/Payments tab. Highlight the payment record, then click on the Edit icon . After making a change, click on the Save icon .

Try again

Once you have fixed the problem contract, rerun the DBR and check the balance.