Unless you process your transactions in Money Management daily this is to be expected. The Daily Gross Sheet answers a very important question, "When did I take the funds to the bank?" As long as you take your deposit to the bank when you process the payments through Money Management you should be able to reconcile your Daily Gross Sheet with your bank statement. A transaction does not appear on the Daily Gross Sheet until you process the transaction through Money Management. The date on the Daily Gross Sheet provides tracking information as to exactly when you took the money to the bank.

If you do not process the transactions in Money Management daily, you still should be able to reconcile your Daily Gross Sheet with your Projection Sheet as long as you close out your transactions by the end of each month. By 'closing out your month' we mean to have all of your transactions either deposited, sent to collections, voided, processed as owner complimentary, etc., by the last day of the month. Many times the Daily Gross Sheet for the first day of the month has transactions for the 29th, 30th, and 31st of the previous month, which means the previous month was not 'closed out.'

Since many facilities report their numbers at the end of the month it is a good idea to have everything processed by month's end. As long as you do this each month you should be able to reconcile your Daily Gross Sheets for the month with the Projection Sheet. Remember, refunds do not show up on the Daily Gross Sheet and the amounts on the Daily Gross Sheet are inclusive of tax. This means you would need to subtract any refunds issued, items sent to collections, and the tax obligation from the sum of your Daily Gross Sheet in order to accurately compare the data to the adjusted revenue on the Projection Sheet.

A useful tip is that every single number on the Projection Sheet can be explained. Let's say you had a really large adjustment on the 4th of May. You would simply select the 4th of May on the upper right-hand date selector of the Paperwork section. Click the Adjustments tab, and then click Details. The Projection Sheet Adjustment Details report shows you exactly what items were used to calculate the number on the Projection Sheet.