SVB T&E has a seamless integration with Quickbooks Online for both reimbursable expenses and corporate card expenses.
How does the sync work for reimbursable expenses (Cash Mode)?
- SVB T&E processes reimbursements via batched ACH transfers on a nightly basis
- When the ACH transfer is initiated via expense approval, we push a Bill & Bill Payment into Quickbooks for the same transfer amount, making reconciliation easy
To give you a better idea of what this will look like, these screenshots show you a Bill and Bill Payment in QBO:
Bill:
Bill Payment:
How does the sync work for reimbursable expenses (Accrual Mode)?
With the accrual sync, we will create a new purchase transaction for each expense against an SVB T&E Clearing account (type = Bank account), and each transaction is dated based on the date of the expense. We will also create a bank transfer in the amount of the associated debit from your bank register to the SVB T&E Clearing account.
Each time we debit the company bank account, we will also create a bank transfer from the SVB T&E Clearing account to your Operating Bank Register (where debits come out of). You will need to reconcile the bank transfer with the debit in your Bank Register.
Reconciled vs. Unreconciled status in the Clearing Account
The purchase transactions (i.e. expenses) will come into the clearing account as 'reconciled.' The bank transfers will be 'unreconciled.'
Reconciling the bank transfers is a one-step process:
1) In your Operating Bank Register, match the bank transfer to the corresponding bank debit. This will automatically change the status of the transaction to 'reconciled' in the SVB T&E Clearing account.
To enable this feature, select the Accrual accounting button in your Accounting Sync page in your company settings. The first time you approve a batch of expenses, the SVB T&E Clearing Account will be automatically created.
How does the sync work for corporate card expenses?
- When an admin approves corporate card expenses in SVB T&E, Corporate Card transactions are synced into QB as an Expense to the designated Corporate Card register.*
- The date the transaction was made is synced to the Payment Date, to ensure it is synced to the appropriate QB period.
- We recommend you also connect your Credit Card program to QB, so as to benefit from QB's 'matching' functionality, where the expenses synced into QB by SVB T&E to the corporate card register can be 'matched' to the card transactions being imported by QB, ensuring a streamlined reconciliation process each month.
*Please note: if you've turned on Accounting Review setting, then corporate transactions will be synced manually on the Accounting Integration page.
The record we create in QB will include the account, and the description field will include the cardholder, note, and a link back to the expense in SVB T&E where you can view the receipt:
Here's what it will look like when corporate card transactions have matched with the corresponding transaction from your bank statement:
To reconcile, click the "match" button:
You are able to match transactions in bulk. Select the desired transactions by checking the transaction's "Check Box" on the left or all the transactions by checking the top "Check Box". Then click "Batch Actions" and choose "match".
How does the sync work for billable expenses?
SVB T&E is able to indicate when expenses are billable back to the customer. For more information on how to indicate if an expense is billable, check out this article.
To sync billable expenses to your QuickBooks, you must create an Expense Field and map it to your customer list. Please review instructions on creating an Expense Field here.
Once these features are set up, here's how it will work in Quickbooks:
For reimbursable expenses, the billable expense will show a check mark in the "Billable" field:
Since the expense is associated with a customer from your customer list in QuickBooks, the expense will also be listed under the customer as a 'billable expense charge.' The status will be 'open' and you'll see the option to start an invoice: