- Go to Sales or Financials and select Review deposits
- On the left-hand task bar select Edit Process
- Make sure that you have selected "Payment date" in the drop-down for "Deposit date:"
Note: Not all reports contain the same information. For daily cash and revenue reconciliation we strongly recommend the Total Revnue Report and Deposit Report.
Running the Total Revenue and Payments Report for Financial Reconciliation
- Go to Revenue or Financials and from the Reports column choose Total Revenue and Payments
- To begin, choose a single date from the Date drop-down where you have processed deposits and closed out all drawers
- Mark the Check-box to include taxes and Security Deposits
- Mark the Check-box to show payment Method distribution
- When running the report for a single day, it's reccommeded to Sort by Transaction type, otherwise, the sort should remain at the default of by Date
- Click View Report
Running the Deposit Report for Financial Reconciliation
- Go to Revenue or Financials and from the Reports column choose Deposits
- To begin, choose the same date(s) used on the Total Revenue and Payments report
- Mark the Check-box for Summary (Details can be enabled to help track down differences, but makes the report longer)
- Click view report
- A page will be displayed for each deposit on the date(s) selected
- Compare the summary amounts from the deposit report by payment method to the Payment summary on the Total Revenue and Payments report.
- Once these agree, you can match this to the General Ledger post file if GL is being used, otherwise, these reports will serve as the source documents for making journal entries.
If the two reports do not agree, there are some common reasons for the details not to match:
- If the no results display on the deposit, make sure that you have run the deposit process.
- If there are items missing from the Deposit report, it's possible that a drawer wasn't closed or approved and thus never made it into the deposit process or into the deposit report.
- The deposit report will show corrections from cash drawers begin closed with an over/short amount. These cash adjustments will not be displayed on the Total Revenue and Payments report.
- Make sure that you have not opted to include pledge commitments not received on the revenue report, this will over state that report by the amount of outstanding pledge installments.
- Some Payment methods such as, Gift certificate, Pre-Altru, or Transfers among others are non-depositable payments and thus will NOT be in the deposit report. Rules for non-depositable payments are configured in the Tickets area.
- Make sure that you have not opted to Show revenue that moved from unearned to earned