---
title: Review and Reconcile using the Transaction Report
description: Follow these steps to open and verify transaction numbers using the Transaction Report from the Manager Portal.
---

[Skip to content](https://support.getunion.com/knowledge/review-and-reconcile-using-the-transaction-report#main-content)

English

Show submenu for translations

[Still need help?](https://support.getunion.com/knowledge/kb-tickets/new?hsLang=en) [Customer portal](https://support.getunion.com/getting-started?hsLang=en)

![union app icon.png\]](https://support.getunion.com/hs-fs/hubfs/union%20app%20icon.png?height=40&name=union%20app%20icon.png)

- [Default HubSpot Blog](https://9012127.hs-sites.com/blog)

Open main navigation

Close main navigation

- [Default HubSpot Blog](https://9012127.hs-sites.com/blog)
- English
  
  Show submenu for translations
- [Still need help?](https://support.getunion.com/knowledge/kb-tickets/new)
- [Customer portal](https://support.getunion.com/getting-started)

 Always ready to support you

- There are no suggestions because the search field is empty.

1. [Union Support](https://support.getunion.com/knowledge?hsLang=en)
2. [Portal](https://support.getunion.com/knowledge/portal?hsLang=en)
3. [Reports](https://support.getunion.com/knowledge/portal?hsLang=en#reports)

# Review and Reconcile using the Transaction Report

## Follow these steps to open and verify transaction numbers using the Transaction Report from the Manager Portal.

1. Log in to the [Manager Portal](https://manager.union-pos.com/) and open the Transactions Report. 
     1. Select the hamburger menu (three lines) on the upper-left.
     2. Select "Reports".
     3. On the Reports submenu, select "Transactions".
2. Log in to CardConnect.  
   ***\> Note:** If you do not have access to CardConnect, contact Union support for access.*  
     1. Select "Reporting".
     2. Select "Funding".
3. Match your Transaction Report date to its CardConnect funding date.  
   ***\> Note:** Funding dates are generally 1 or 2 days after transactions.*  
   *Example: Transaction Report date of 01/01 and CardConnect funding date 01/02 or 01/03*
4. Compare numbers to ensure that they line up exactly.  
   ***\> Note:** The "Sales" line on the CardConnect data should be your true deposit number (before CardConnect fees).*  
     1. Export the Transaction Report into a fresh Google Sheet or Excel spreadsheet.
     2. To the far right of existing data, add a column for Funding Date and insert the date from CardConnect.
     3. In a row below existing data, add a =sum (in [Google Sheet](https://support.google.com/docs/answer/3093669?hl=en) and [Excel](https://support.microsoft.com/en-us/office/sum-function-043e1c7d-7726-4e80-8f32-07b23e057f89#:~:text=The%20SUM%20function%20adds%20values,values%20in%20cells%20A2%3A10.)) function for all cells with dollar amounts.
     4. Compare your final sum with the funded amount reported by CardConnect.
     5. If necessary, go through each transaction individually (searching by last 4 of Card Number) and compare transactions with the CardConnect data.

**RESULT**

If a deep-dive comparison does not reconcile your batches, your batches might be splitting (being batched out on multiple days), or the processor may be withholding funds daily instead of monthly.

If you have any questions or concerns about reconciliation, please contact Union so that we can investigate further with you.

 

- [Portal](https://support.getunion.com/knowledge/portal?hsLang=en#main-content)

    - [Menu](https://support.getunion.com/knowledge/portal?hsLang=en#menu)
    - [Reports](https://support.getunion.com/knowledge/portal?hsLang=en#reports)
    - [Permissions](https://support.getunion.com/knowledge/portal?hsLang=en#permissions)
- [Hardware](https://support.getunion.com/knowledge/hardware?hsLang=en#main-content)

    - [Printer](https://support.getunion.com/knowledge/hardware?hsLang=en#printer)
    - [Terminal](https://support.getunion.com/knowledge/hardware?hsLang=en#terminal)
    - [Card Readers](https://support.getunion.com/knowledge/hardware?hsLang=en#card-readers)
    - [Hardware Process](https://support.getunion.com/knowledge/hardware?hsLang=en#hardware-process)
    - [Network](https://support.getunion.com/knowledge/hardware?hsLang=en#network)
- [POS](https://support.getunion.com/knowledge/pos?hsLang=en#main-content)

    - [Offline Mode](https://support.getunion.com/knowledge/pos?hsLang=en#offline-mode)
    - [Permissions](https://support.getunion.com/knowledge/pos?hsLang=en#permissions)
    - [Tab Management](https://support.getunion.com/knowledge/pos?hsLang=en#tab-management)
    - [Process](https://support.getunion.com/knowledge/pos?hsLang=en#process)
- [Integration](https://support.getunion.com/knowledge/integration?hsLang=en#main-content)

    - [Partners](https://support.getunion.com/knowledge/integration?hsLang=en#partners)
- [Network](https://support.getunion.com/knowledge/network?hsLang=en)
- [Process](https://support.getunion.com/knowledge/process?hsLang=en#main-content)

    - [Processing](https://support.getunion.com/knowledge/process?hsLang=en#processing)
- [Support](https://support.getunion.com/knowledge/support?hsLang=en#main-content)

    - [Menu](https://support.getunion.com/knowledge/support?hsLang=en#menu)
    - [POS](https://support.getunion.com/knowledge/support?hsLang=en#pos)
    - [Processing](https://support.getunion.com/knowledge/support?hsLang=en#processing)
    - [Reports/Reporting](https://support.getunion.com/knowledge/support?hsLang=en#reports-reporting)
- [parts.getunion.com](https://support.getunion.com/knowledge/parts-getunion-com?hsLang=en)
- [Payment Processing](https://support.getunion.com/knowledge/payment-processing?hsLang=en)

- [Default HubSpot Blog](https://9012127.hs-sites.com/blog)

[![Chill listening crop-3](https://support.getunion.com/hs-fs/hubfs/Union%20Logo.png?width=72&height=24&name=Union%20Logo.png "Chill listening crop-3")](https://getunion.com/)

<https://www.facebook.com/Tabbedout> <https://www.instagram.com/tabbedout/>

Copyright © 2026, Union