View transactions that are part of each deposit
Log into your ESS account and click Accounting/Financials from the Reports dropdown Menu.
Under the Accounting/Financials section, click Payment Processing - Deposits. This report shows the list of deposits that you will see in your bank account.
Reconcile deposits in QuickBooks
- Log into QB and go to the Banking or Transactions tab on the left hand side.
- From here, select the deposit that you would like to reconcile and click Find match.
- This will take you to a list of names that have not been matched to a deposit yet.
- From here, go back into the ESS website and find the deposit that you're trying to reconcile.
- Select all of the customers in QB that are apart of the deposit and be sure that the number on the right side matches the "Gross" amount in ESS.
- After selecting all customers and entering in the amounts, you should have a difference that needs to be resolved.
- To fix the difference, scroll to the bottom of the page and find the switch button that has "Resolve" on the left side and "Difference" on the right.
- This will bring up a line down below that you can enter "ESS" as the Payee and select the category that you would like to code the expense to (Credit card processing fees, merchant fees, etc.). Then enter the Fee amount from ESS as a negative which should reconcile accounts.