Reconciling Transactions

EzyStream makes it easy to reconcile your bank account settlement. Here's an overview of what to do.

Understanding Batches

Each time we settle to one of your bank accounts, we create a batch payment. This includes all your received transactions within a certain period/up until a specific date. Each batch amount will exactly equal the equivalent csv transaction report generate by our system.

Accessing Reports

To see what transactions are contained within a batch:

  1. Login to your EzyStream dashboard.
  2. Go to your Manage menu and select Giving.
  3. Click Reports in the top left corner.
  4. Under Past Payouts, find the batch you'd like to reconcile.
  5. Download the CSV file.
  6. Open the CSV file to see all transactions, including the Gross Amount of each transaction.
  7. We suggest coding each Gross Donation Amount to the Donor's account.
  8. Then code the EzyStream Fees at the bottom of the CSV to your transaction expense account. In Xero you can do this as a 'Receive Money' transaction with a negative amount.  See the example below.
  9. When combined together, this will give you a total which matches the batch total.

Example Reconciliation Transaction in Xero

Here's what your transaction in Xero would look like. Transaction amounts are for explanation purposes and do not represent the amounts actually charged by EzyStream Giving.



Struggling to find an answer to your question? Send us an email: help@ezystream.com