What Is The QuickBooks Integration?

If you’re using QuickBooks Online as your accounting service, you can integrate your Arryved daily sales data directly into QBO. This integration saves you time by automating the tedious task of manual bookkeeping! Keep reading for an overview of using the QuickBooks Integration with Arryved. 

Prerequisites

• You need the QuickBooks Online Plus subscription level to integrate QBO with Arryved (not Advanced, Essentials, or Simple Start).

Limitations

• You must be using QuickBooks Online (QBO). If you’re using QuickBooks Desktop, you’ll need to integrate your Arryved POS data with Ekos or Shogo who can send your Arryved data to QB Desktop for you. 

• Pro Tip!: Even if you’re using QuickBooks Online, you can choose to use Ekos or Shogo to make the QuickBooks + Arryved Integration even easier on you!

• If you’re using the Shogo or Ekos integrations, don’t complete the steps in this guide. Doing so will cause double entry. Please reach out to your Shogo or Ekos representative to get started and use these guides instead: 

• Ekos Integration Setup Guide

• Shogo Integration Overview

• The data sync time is 10 am MST. The sync time can’t be adjusted. 

• The Daily Sales Receipts in this integration don’t show a breakdown of sales numbers by Category, Item Type, or individual checks. 

• Please defer any accounting questions to your CPA or finance professional. 

How It Works

When integrated, Arryved exports a Daily Sales Receipt into your QuickBooks Online. You can then use those Sales Receipts to find a match between your saily sales and your bank deposits. 

Benefits

• Automates the dreadful task of manual bookkeeping.

• Your QBO is updated daily. 

• Creates monthly/quarterly/annual tax reports.

• Ability to cross-reference your POS sales with your bank deposits.

Daily Sync

Your Daily Sales Receipt is imported into your QuickBooks Online at 10 am MST daily. This sync time can’t be adjusted, it needs to happen after batch time (at 4 am MST) with enough wiggle room in between to flag and reconcile any errors. 

The Daily Sales Receipt includes:

• Transactions paid by Cash, Credit Card, and Check

• Add-on, Inclusive, and Use Tax

• Tips

• RSF

• Donations

• Gift Card and Deposit liabilities

• Net Sales

Below is an example of a Daily Sales Receipt imported into your QBO. 

• Cash, Credit Card, and check amounts appear negative because they’re in your Undeposited Funds account which is just a holding account until your bank deposit comes through. 

• The totals in the bottom right are $0.00 because the Sales Receipt is just a record of the money you expect to receive. 
  

Matching Sales Receipts To Bank Deposits 

This integration is designed to help you match your Daily Sales Receipts in QBO with your daily bank deposits. 

• In QBO, on your Banking Dashboard, click on a deposit, click ‘Find Match’, and select the corresponding Daily Sales Receipt(s). 

• For deposits that are combined (e.g. Saturday + Sunday) you’ll need to select both Daily Sales Receipts. 

• Refer to the ACH Deposit FAQs for a refresher on your daily deposit schedule. 

Net Sales

Your liabilities (Gift Cards and Deposits) can be either included or excluded from your Net Sales in your QuickBooks reporting. 

If you launched with Arryved after 6/1/21, your liabilities are excluded by default. If you launched prior to that date, your liabilities are included by default. 

• You can find out how your Net Sales calculate or change this preference by contacting our award-winning Support Team at support@arryved.com. 

If liabilities are included in your Net Sales, then they won’t be reported separately in your QBO Daily Sales Receipt. If they’re excluded from Net Sales, then they report separately. 

Next

Ready to integrate your QuickBooks Online with your Arryved POS?

1. Contact support@arryved.com to get started.

2. Use the QuickBooks Integration Setup Guide.