Reconciling your Credit Card Bank Deposits
Reconciling your Credit Card Bank Deposits
As a regular part of the business route, many of our merchants will reconcile their credit card deposits against their credit card sales to ensure they're receiving proper payment from the processor.
We have a couple of different data sources that we encourage our merchants to use to reconcile their credit card deposits:
- Daily Sales Summary
- Daily Payments Report
- Quickbooks Online Integration
- Shogo Integration
Note: If reconciling your deposits on a daily basis, each deposit will be a single day's transactions except for Monday. Monday will be Friday and Saturday's sales combined. You can read more about the ACH deposit schedule here.
1. Daily Sales Summary
This report is accessible through the Arryved Portal (under the Analytics tab) or by receiving this report on a regular cadence from our report email service run by Rosie.
|
2. Daily Payments Report
This report is accessible through the Arryved Portal (under the Reporting tab, then select Accounting). The report includes all types of payments such as cash, gift cards, credit cards (displayed as NMI), and credit card refunds. The report may be sent you via email on a daily or otherwise requested cadence if you reach out to support@arryved.com.
- Each row in this report will represent one day of payment data.
- The NMI column will generally represent your credit card transactions by day and should match the deposit in your bank.
- One exception to the NMI and bank deposit matching will be if you have had a refund entered through the Arryved Portal. A column will show you any refund values which will require you to subtract that value from the NMI value to get your deposit number to match.
3. Quickbooks Online Integration
If enabled, Arryved will send basic daily sales and payments into your Quickbooks Online account for daily accounting procedures, including deposit reconciliation. Refer to these articles to read more about the feature and configuration to determine if this is an option for you.
4. Shogo Integration
Arryved partnered with Shogo to provide an in depth API that allows us to send our sales and payments data to over to them. Shogo has then integrated with multiple accounting partners to provide a flexible solution depending on your accounting software choice.
- Shogo charges a small monthly fee for this service.
- Shogo will be your best resource to provide guidance on managing your daily reconciliation as this will be dependent on the accounting solution.
Related Articles
ACH Credit Card Deposit FAQs
ACH Credit Card Deposit FAQs What is an ACH deposit? ACH, or the Automated Clearing House network, is how money is sent electronically from one bank to another. Money routes from your guests’ bank accounts to your business account via ACH deposits on ...Forced Tip Claim Overview
What Is Forced Tip Claim? Forced Tip Claim is a replica of our Cash Actions tool that forces the Cash Actions prompt when an employee clocks out of Arryved Service. This is helpful for ensuring your employees are recording the tips they’re walking ...Emp. Cash Handling Report Overview
What Is The Emp. Cash Handling Report? The Emp. Cash Handling report documents any actions completed through Cash Actions or Forced Tip Claim in Arryved Service. Actions are grouped by the employee who performed them so you can see a breakdown of ...TSYS Account Resource Guide
TSYS Resources During your onboarding with Arryved, you created an account with the payment processor that we work with, TSYS. They are the company that handles your daily credit card deposits, monthly fee withdrawals, PCI compliance, and any ...How To Test Gift Card Compatibility
Gift Card Compatibility Were you selling gift cards with your previous POS? Do you have blank gift cards left over you’re hoping to load and sell through Arryved? We can help determine if your physical blank gift cards are compatible with the Arryved ...