Overview
The Credit Card Deposits report can download your card payouts as a CSV file that QuickBooks Online imports as journal entries. Each payout becomes one journal entry. That entry records the net amount deposited to your bank, the processing fees, and the gross card sales.
Use it to book your card deposits in QuickBooks without typing each payout in by hand. The export covers the date range and merchant you have selected on the report.
Before you start
You need three accounts in your QuickBooks Online Chart of Accounts. You type their names into SMRT when you export.
Field in SMRT | What it is | Typical QuickBooks account type |
Deposit account | Where the payout lands, usually your business checking account | Bank |
Fees account | Card processing fees charged by your processor | Expense |
Sales account | The full (gross) value of the card sales in the payout | Income, or a clearing account (see below) |
The names must match your QuickBooks accounts exactly, including spelling and capitalization. SMRT fills in placeholder names like "Stripe Deposits". Replace them with your own account names unless you created accounts with those exact names.
Choosing the Sales account. If you already record your sales in QuickBooks some other way, such as a daily sales summary, do not point this export at an income account. Doing so records the same sales twice. Use a clearing account such as Undeposited Funds instead. If you are unsure, ask your accountant before your first import.
Export from SMRT
Open the Credit Card Deposits report.
Choose the Time-frame and Merchant you want to export. Check that the payouts listed are the ones you want in QuickBooks.
Click Export to Accounting, then choose QuickBooks Online.
In Starting voucher number, enter the next unused journal number in QuickBooks.
The first payout uses this number, and each later payout uses the next number up.
SMRT does not remember this number. It resets to 1001 every time. Note the last number used after each export.
Enter your Deposit account, Fees account and Sales account names.
SMRT remembers these names for next time, but only on this computer and browser.
Click Export. A CSV file downloads to your computer.
Import into QuickBooks Online
In QuickBooks Online, click the gear icon (Settings), then Import data.
Choose Journal entries.
Upload the CSV file you downloaded from SMRT.
Map each column in the file to its QuickBooks field:
Journal No. → Journal No.
Journal Date → Journal Date
Account Name → Account
Journal/Description → Description
Debits → Debits
Credits → Credits
Set the date format to MM/DD/YYYY if QuickBooks asks.
Review the entries QuickBooks shows you, fix any flagged rows, and click Import.
QuickBooks menu names can vary by region and plan. If you can't find Import data, see Intuit's help for importing journal entries.
What the file contains
Each payout on the report becomes one balanced journal entry with three lines. For example, a payout of $609.61 in card sales with $25.11 in fees deposits $584.50:
Journal No. | Journal Date | Account Name | Description | Debits ($) | Credits ($) |
1001 | 11/04/2026 | Your deposit account | Stripe payout | 584.50 |
|
1001 | 11/04/2026 | Your fees account | Stripe payout | 25.11 |
|
1001 | 11/04/2026 | Your sales account | Stripe payout |
| 609.61 |
The journal date is the estimated bank arrival date shown on the report. The description always reads "Stripe payout", whichever card processor you use.
Troubleshooting and FAQ
QuickBooks says an account doesn't exist. The account name in the file doesn't exactly match your Chart of Accounts. Export again with the exact name, or create the account in QuickBooks first.
QuickBooks flags duplicate journal numbers. The starting voucher number was already used. Export again starting from the next unused number.
A line has no debit or credit amount. This happens when a payout had no processing fees. Delete that line in the file, or skip it during the import review.
My account names reset to the defaults. SMRT saves them only in the browser you exported from. Enter them again on a new computer or browser, or after clearing browser data.
Can I export the same payouts twice? Only if you delete the first import from QuickBooks. Otherwise the deposits are recorded twice. Export each date range once, and pick the next range so it starts where the last one ended.
Does this work with other accounting software? The same menu also exports for Xero, e-conomic, sevDesk and e-računi. The steps in SMRT are the same, but the import steps differ in each product.