--- title: "Reconciliation Tool for Recreation Management Payments" slug: "reconciliation-tool-recreation-management-payments" description: "Streamline your card and ACH payment reconciliation in CivicPlus Payments with our detailed workbooks and instructions for accurate financial management." updated: 2026-07-24T13:38:32Z published: 2026-07-27T13:00:02Z canonical: "www.civicplus.help/reconciliation-tool-recreation-management-payments" --- > ## Documentation Index > Fetch the complete documentation index at: https://www.civicplus.help/llms.txt > Use this file to discover all available pages before exploring further. # Reconciliation Tool for Recreation Management Payments The following instructions and workbooks help with reconciling card and ACH payments in CivicPlus Payments and Recreation Management. You can choose from a Gross or Net [reconciliation workbook option](/civicplus-help-center/docs/reconciliation-tool-recreation-management-payments#reconciliation-workbooks). > [!NOTE] > Important Notes > > - This tool only works if you are using CivicPlus Payments in Recreation Management. > - This tool will not reconcile refunds from before December 16, 2025 due to a technical issue with the Transaction ID displaying. > - This tool is intended to help with reconciliation for **Card and ACH payments only**. Including Cash/Check Items will cause mismatches. > - You must "enable content" for this tool to function. This workbook does not use any external references. > - Utilizing additional data or tabs in the workbooks other than what is specified below is allowed, however, it is not supported by CivicPlus. ## Reconciliation Workbooks - [Reconciliation Tool: Gross (XLSX)](https://cdn.us.document360.io/17dc564a-8310-4f61-b929-1bd73b36e158/Images/Documentation/Recreation%20Management%20Payments%20-%20Reconciliation%20Tool%20(Gross).xlsx?sv=2026-02-06&spr=https&st=2026-11-21T21%3A52%3A08Z&se=2026-11-21T22%3A52%3A08Z&sr=b&sp=r&sig=niyC1H1TscZcop15jllTtWU1irKOQvXVxn4b4eneCzA%3D) - [Reconciliation Tool: Net (XLSX)](https://cdn.us.document360.io/17dc564a-8310-4f61-b929-1bd73b36e158/Images/Documentation/Recreation%20Management%20Payments%20-%20Reconciliation%20Tool%20(Net).xlsx?sv=2026-02-06&spr=https&st=2026-11-21T21%3A52%3A08Z&se=2026-11-21T22%3A52%3A08Z&sr=b&sp=r&sig=H%2Fcf2r7DXQSqAmtk34g%2BbTR%2F5TB24A5e0tyZLTMEYiE%3D) --- ## Instructions 1. [Log in to your CivicPlus Payments Portal](https://pay.civicplus.com) 2. In the Payments Portal, navigate to the **Gateway Configurations** tab ![](https://cdn.us.document360.io/17dc564a-8310-4f61-b929-1bd73b36e158/Images/Documentation/Gateway Configurations - Payments.png?sv=2026-02-06&spr=https&st=2026-11-21T21%3A52%3A08Z&se=2026-11-21T22%3A52%3A08Z&sr=b&sp=r&sig=4pUjhQYftk%2BTEDjAWZ%2FplFeI38wLYLmnGFqkmpgpjO0%3D) 3. Click **View Reports** on your configuration ![Gateway configurations overview with options to view reports.](https://cdn.us.document360.io/17dc564a-8310-4f61-b929-1bd73b36e158/Images/Documentation/View%20Reports%20-%20Payments.png?sv=2026-02-06&spr=https&st=2026-11-21T21%3A52%3A08Z&se=2026-11-21T22%3A52%3A08Z&sr=b&sp=r&sig=ZbfmUBcRprO6QvEEpwtsLv%2FU2fMNEiwRLBMYC6n2XfU%3D) 4. Select the **Deposit Report**, and then click on the **Export** icon ![The Deposits report tab with the export icon highlighted.](https://cdn.us.document360.io/17dc564a-8310-4f61-b929-1bd73b36e158/Images/Documentation/Export Deposits Report - Payments.png?sv=2026-02-06&spr=https&st=2026-11-21T21%3A52%3A08Z&se=2026-11-21T22%3A52%3A08Z&sr=b&sp=r&sig=Uwsb4og4CdsWvfCOoICBJDA797n1uI25oVRU6x%2BKwW8%3D) 5. Set your **Date Range** as appropriate and click **Export** ![Export deposit details with date range options for previous, current, or custom months.](https://cdn.us.document360.io/17dc564a-8310-4f61-b929-1bd73b36e158/Images/Documentation/Export%20Deposits%20Report%20Dates%20-%20Payments.png?sv=2026-02-06&spr=https&st=2026-11-21T21%3A52%3A08Z&se=2026-11-21T22%3A52%3A08Z&sr=b&sp=r&sig=XmM7h7bonmtDdfj82yrtNjGRzpPdHz5QUTTBKBbcv8s%3D) > [!WARNING] > Note: > > You may export a maximum of 30 days at a time. You may copy multiple exports into the reconciliation workbook table. Just ensure the table encompasses all transactions. 6. Select the **Payments Report**, and then click on the **Export** icon ![The Payments report tab with the export icon highlighted.](https://cdn.us.document360.io/17dc564a-8310-4f61-b929-1bd73b36e158/Images/Documentation/Export%20Payments%20Report%20-%20Payments.png?sv=2026-02-06&spr=https&st=2026-11-21T21%3A52%3A08Z&se=2026-11-21T22%3A52%3A08Z&sr=b&sp=r&sig=IEzvfhla%2BDjGkeH0I90M4eICGsWP9obmI4rMMDnncHM%3D) 7. Set your **Date Range** as appropriate and click **Export** ![Export payments dialog showing date range options and export button for transactions.](https://cdn.us.document360.io/17dc564a-8310-4f61-b929-1bd73b36e158/Images/Documentation/Export%20Payments%20Report%20Dates%20-%20Payments.png?sv=2026-02-06&spr=https&st=2026-11-21T21%3A52%3A08Z&se=2026-11-21T22%3A52%3A08Z&sr=b&sp=r&sig=0jvYXGC9lBgcA%2FwV%2B26CMs%2BmU4sDmcGmyPTHPQcj8Ik%3D) > [!WARNING] > Note: > > This information can be determined by the First and Last dates for a Card transaction. The Payments report exports in UTC so we recommend adding one day to your end date to get all the in-scope transactions. 8. Copy and paste your Deposit Report's data into the **Deposits Report** tab of the [Reconciliation Workbook](/civicplus-help-center/docs/reconciliation-tool-recreation-management-payments#reconciliation-workbooks) (will say either Gross or Net, depending on the option selected) ![Spreadsheet displaying a deposits report with various columns and empty rows.](https://cdn.us.document360.io/17dc564a-8310-4f61-b929-1bd73b36e158/Images/Documentation/Deposits%20Report%20Tab%20-%20Payments.png?sv=2026-02-06&spr=https&st=2026-11-21T21%3A52%3A08Z&se=2026-11-21T22%3A52%3A08Z&sr=b&sp=r&sig=f8W9LSZU4ZRR2EI3WjjAQciK6BDcC3GomsCVTNsTbjc%3D) > [!WARNING] > Note: > > It is recommended that you do not include the header line, and paste your information into A2. 9. Copy and paste your Payments Report's data into the **Payments Report** tab of the [Reconciliation Workbook](/civicplus-help-center/docs/reconciliation-tool-recreation-management-payments#reconciliation-workbooks) ![Spreadsheet showing a Payments Report with various transaction details and columns.](https://cdn.us.document360.io/17dc564a-8310-4f61-b929-1bd73b36e158/Images/Documentation/Payments%20Report%20Tab%20-%20Payments.png?sv=2026-02-06&spr=https&st=2026-11-21T21%3A52%3A08Z&se=2026-11-21T22%3A52%3A08Z&sr=b&sp=r&sig=5FjThOMRJbBFWPl%2BP9MMWohB1UXDP%2F4lZ7XFneBqYYk%3D) > [!WARNING] > Note: > > It is recommended that you do not include the header line, and paste your information into A2. 10. In Recreation Management, click **Reports**, select **Transaction Reports**, and select the **Transaction Detail Report** ![Reports navigation menu showing the Transaction Reports tab and a highlighted Transaction Detail report.](https://cdn.us.document360.io/17dc564a-8310-4f61-b929-1bd73b36e158/Images/Documentation/Reports,%20Transaction%20Detail%20-%20Rec.png?sv=2026-02-06&spr=https&st=2026-11-21T21%3A52%3A08Z&se=2026-11-21T22%3A52%3A08Z&sr=b&sp=r&sig=AZgeWF78GE6RxVmbdBD81xBWdyEkSWnaWS%2FChyuLH0Y%3D) 11. Ensure your Transaction Report is configured for the appropriate **Date** and **Time Ranges**, and that the following **filters and fields** are added: ![Transaction detail section showing date and time filters for reporting purposes.](https://cdn.us.document360.io/17dc564a-8310-4f61-b929-1bd73b36e158/Images/Documentation/Transaction%20Detail%20Filters%20and%20Fields%20-%20Rec.png?sv=2026-02-06&spr=https&st=2026-11-21T21%3A52%3A08Z&se=2026-11-21T22%3A52%3A08Z&sr=b&sp=r&sig=5tonIGL4oq%2BmCj4TjSsrodyWBphhP9NWlhBu2CzidlY%3D) - **Date:** Remember to include the hours of the day before that were after the cutoff time. - **Filters:** On the Payment Types section, select **Credit/Debit** ![Filters section showing payment types with Credit/Debit selected for transactions.](https://cdn.us.document360.io/17dc564a-8310-4f61-b929-1bd73b36e158/Images/Documentation/Credit%20Debit%20Filters%20on%20Transaction%20Detail%20Report%20-%20Rec.png?sv=2026-02-06&spr=https&st=2026-11-21T21%3A52%3A08Z&se=2026-11-21T22%3A52%3A08Z&sr=b&sp=r&sig=cr2IA6QGB2WSn3EOD1B8s7xojdeHoOqXs300LdDpbUQ%3D) - **Transaction Fields:** Select **Receipt #**, **Transaction Date/Time**, **CC Last Four**, **CC Type**, **Merchant Code**, **Payment Gateway**, **Receipt Location**, **Transaction Detail GL Code**, **Transaction Detail GL Description**, **Payment Types** (Will show as Credit/Debit) ![Transaction fields with selected options for data filtering and reporting purposes.](https://cdn.us.document360.io/17dc564a-8310-4f61-b929-1bd73b36e158/Images/Documentation/Transaction%20Fields%20for%20Reconciliation%20-%20Rec.png?sv=2026-02-06&spr=https&st=2026-11-21T21%3A52%3A08Z&se=2026-11-21T22%3A52%3A08Z&sr=b&sp=r&sig=CFGy8a3Uqc0F7xYB1wHdOyc7ndF2lh1FwtoAEpuqrPM%3D) - **Payer Fields:** Select **User Full Name** ![User Full Name is selected in the Payer Fields section of the interface.](https://cdn.us.document360.io/17dc564a-8310-4f61-b929-1bd73b36e158/Images/Documentation/Payer%20Fields%20-%20User%20Full%20Name%20-%20Rec.png?sv=2026-02-06&spr=https&st=2026-11-21T21%3A52%3A08Z&se=2026-11-21T22%3A52%3A08Z&sr=b&sp=r&sig=Zo%2BE%2F2E8LiRtYSZxbP7kfAwxm7KBWLZDCPvnVCeYkBM%3D) 12. After verifying that you have the correct settings, **Export** the Transaction Report as normal ![Transaction detail report with the Export icon highlighted](https://cdn.us.document360.io/17dc564a-8310-4f61-b929-1bd73b36e158/Images/Documentation/Export%20Transaction%20Detail%20Report%20-%20Rec.png?sv=2026-02-06&spr=https&st=2026-11-21T21%3A52%3A08Z&se=2026-11-21T22%3A52%3A08Z&sr=b&sp=r&sig=%2BM7HTZzkM9FH5PI9sOQAHALYG4u3aEBSQvHWj7kG764%3D) > [!WARNING] > Note: > > If you save this report the fields will stay and you will only need to verify the date and time. 13. Copy and paste your report's data into the **GL Recon Report** tab of the [Reconciliation Workbook](/civicplus-help-center/docs/reconciliation-tool-recreation-management-payments#reconciliation-workbooks) ![Spreadsheet showing GL Recon Report with various financial columns and empty rows.](https://cdn.us.document360.io/17dc564a-8310-4f61-b929-1bd73b36e158/Images/Documentation/GL%20Recon%20Report%20-%20Payments.png?sv=2026-02-06&spr=https&st=2026-11-21T21%3A52%3A08Z&se=2026-11-21T22%3A52%3A08Z&sr=b&sp=r&sig=J3jd6xmS%2B0XJFFd1VenlbI23MfUCwBVZDQOQBGvPQRA%3D) > [!WARNING] > Note: > > It is recommended that you do not include the header line or the bottom totals, and paste your information into A2. 14. In the **Customer Configuration** tab of the spreadsheet, enter the **First and Last deposit dates,** and select your **Time Zone** ![Spreadsheet showing user configuration settings with highlighted customer configuration section.](https://cdn.us.document360.io/17dc564a-8310-4f61-b929-1bd73b36e158/Images/Documentation/Customer%20Configuration%20-%20Payments.png?sv=2026-02-06&spr=https&st=2026-11-21T21%3A52%3A08Z&se=2026-11-21T22%3A52%3A08Z&sr=b&sp=r&sig=twCJldSmr0sNJRmgNNZ8qt%2BvU8xLSwwyaTZ3Lu%2FKGpA%3D) > [!WARNING] > Note: > > The first and last date of the deposits that are being audited allows the workbook to define scope. Time Zone allows the sheet to convert UTC time to your local time. 15. In the Excel ribbon toolbar, click on **Data**, and in the **Queries & Connections** section, click **Refresh All** ![Excel interface showing the Data tab with Refresh All option highlighted.](https://cdn.us.document360.io/17dc564a-8310-4f61-b929-1bd73b36e158/Images/Documentation/Data,%20Refresh%20All%20-%20Payments.png?sv=2026-02-06&spr=https&st=2026-11-21T21%3A52%3A08Z&se=2026-11-21T22%3A52%3A08Z&sr=b&sp=r&sig=Jo2SxjHbx0K46ufyo7G9I6TAvX0HBRrKgZggW3glzrg%3D) > [!WARNING] > Note: > > If you add or remove data in the Deposits Raw Data or Recreation Management Transaction Report tabs after this step, you will need to perform this step again. 16. Click the **Deposits Aggregator** tab to review the totals for each deposit ![Spreadsheet showing deposits aggregator and related financial data fields.](https://cdn.us.document360.io/17dc564a-8310-4f61-b929-1bd73b36e158/Images/Documentation/Deposits%20Aggregator%20-%20Payments.png?sv=2026-02-06&spr=https&st=2026-11-21T21%3A52%3A08Z&se=2026-11-21T22%3A52%3A08Z&sr=b&sp=r&sig=t3WrG%2B4mluXg3T9Rum2C19B5uiKKhoS%2BG%2BtSYJA997Q%3D) > [!WARNING] > Note: > > This will show you the Total Amount Processed, the Total Fees Assessed (If on Net), and Total Deposited for each deposit. 17. Review the additional tabs of the workbook: ![Spreadsheet showing various tabs including Chargebacks and Carry Overs for financial data.](https://cdn.us.document360.io/17dc564a-8310-4f61-b929-1bd73b36e158/Images/Documentation/Workbook%20Tabs%20-%20Payments.png?sv=2026-02-06&spr=https&st=2026-11-21T21%3A52%3A08Z&se=2026-11-21T22%3A52%3A08Z&sr=b&sp=r&sig=QBzxjRfUS%2BgtX6Z4FLXmatoVfRT3n0SkwmcOTGLAbtk%3D) > [!WARNING] > Notes: > > - These tabs are intended to show you the transactions that need further review at the Transaction Level. > - The **Carry Overs** tab is designed to have the same format as the **Transaction Detail Report**. It is recommended that you Copy/Paste from C2 to the end of the table data, and paste that data into your next reconciliation. This is intended to assist in reconciliation. > - If you paste in the cell directly underneath the last cell in the GL Recon Report, the table should extend to include these automatically. - The **Carry Overs** tab will provide any transactions that are expected to be deposited in a future deposit (Often ACH). - The **Reconciler** tab will allow you to see all transactions (Reconciled or Not) - The **Items to Review** tab will provide a list of transactions that should be reviewed. (These will also be listed in the Reconciler tab.) - The **Chargebacks & ACH Returns** tab is informational, to ensure that these have been seen. - The **Billing Data (Fees)** tab will provide a breakdown of all fees that were charged if a Billing file is present. (This tab is only available on the [Gross Reconciliation workbook](/civicplus-help-center/docs/reconciliation-tool-recreation-management-payments#reconciliation-workbooks).) 18. Perform further research to address any unreconciled transactions listed and re-run any reports needed 19. Review the additional tabs: ![Buttons for reconciliation tools including GL PivotMagic and Reconciliation by GL.](https://cdn.us.document360.io/17dc564a-8310-4f61-b929-1bd73b36e158/Images/Documentation/GL%20Tabs%20-%20Payments.png?sv=2026-02-06&spr=https&st=2026-11-21T21%3A52%3A08Z&se=2026-11-21T22%3A52%3A08Z&sr=b&sp=r&sig=W2ts4ryv30CnsvrIe2x3QgNT400y%2F0Jq%2FL%2FIlp57ItI%3D) - The **GL Pivot Magic** tab will show every transaction summarized by GL Code and Description. It will also indicate how much and what has not been reconciled. - The **Reconciliation by GL** tab provides this same data in an itemized format. Automated Clearing House. A network that allows banks to transfer money electronically between each other. Identification or Identifier. Coordinated Universal Time. General Ledger.