You can import sales into QuickBooks in two shapes: one summary entry per day, built from your till or shop report, or one sales receipt per sale, imported from a spreadsheet. Daily totals keep the books small and match bank deposits easily. Individual receipts keep customer and item detail. Either way, park them in Undeposited Funds until the deposit arrives.
Daily sales summary or one sales receipt per sale?
A daily sales summary records the whole day as one entry: total sales by category, tax collected, and how customers paid. One sales receipt per sale records every transaction separately, with its own customer and items. Most shops and stalls do fine with the summary. Pick per-sale receipts when you need customer history or item-level reports inside QuickBooks.
The choice is about where the detail lives. Your point-of-sale system, payment app or booking tool already keeps every sale. QuickBooks needs enough to produce correct income, correct sales tax and a bank balance that reconciles. Copying all the detail across is optional, and it has a cost: more rows to import, more records to search, and more chances that one bad row throws the day out.
A rule of thumb by business type
| Business | Usual choice | Why |
|---|---|---|
| Cafe or shop with a till | Daily summary | Hundreds of small sales, no named customers |
| Market or event stall | Daily or per-event summary | One card reader report per day |
| Studio selling packages to named clients | One receipt per sale | Customer history matters |
| Online seller with a platform report | Summary per payout | The platform already groups sales into payouts |
These are starting points. If your accountant wants item counts by product every month, a summary that lists each product as a line still gives that, without one record per customer.
What both shapes have in common
Both shapes end with the same totals for the day. If Tuesday's till report says 1,284.50 in sales, Tuesday's income in QuickBooks must say 1,284.50 whichever way you enter it. Decide once, write the decision down, and stick with it. Switching between styles mid-year makes reports hard to compare and makes it easy to enter a day twice.
What a daily sales summary records in QuickBooks
A daily sales summary in QuickBooks is usually a single sales receipt, or a journal entry, that lists the day's sales in lines: one line per sales category, one for sales tax collected, and lines that split the takings by how customers paid. The total equals the money expected to reach the bank, before any fees.
Here is a made-up example for a small bakery on one day. All figures are examples.
| Line | Amount | Where it goes |
|---|---|---|
| Bread and pastries | 812.00 | Sales income |
| Coffee and drinks | 396.00 | Sales income |
| Gift cards sold | 50.00 | Gift card liability, not income |
| Sales tax collected | 26.50 | Sales tax payable |
| Total takings | 1,284.50 | Undeposited Funds |
The till report also says the takings came in as 1,104.50 by card and 180.00 in cash. Those two amounts reach the bank on different days, so it helps to record them as two summary receipts, or as one receipt with the payment split noted, so that each deposit has a clear partner later.
Using items for the categories
If you record the summary as a sales receipt, each sales category is a product or service item in QuickBooks pointed at the right income account. Set these items up once: Bread and pastries, Drinks, Gift cards and so on. Each day you reuse the same items with new amounts. That consistency is what makes a monthly sales-by-item report useful later.
Tax on a summary
Sales tax on a summary is the amount your till says you collected, not a figure QuickBooks recalculates. If your QuickBooks file has sales tax switched on, it may try to calculate tax on each line. Check the tax total on the saved receipt against the till report every time for the first few weeks, until you trust the setup.
Importing individual sales receipts from a spreadsheet
QuickBooks Online can import sales receipts from a spreadsheet through Settings and Import data. Intuit's page of common questions about importing data into QuickBooks Online lists sales receipts among the importable records and gives the file rules: CSV, Excel or Google Sheets, fewer than 1,000 rows.
The same page says QuickBooks uses the first row of the sheet for mapping and does not import it, so that row must hold column headings, not your first sale. It also says lists come before transactions: customers, products and services and the chart of accounts should be in place before you import the receipts that refer to them.
Columns each sale needs
The mapping screen shows which QuickBooks fields it wants, and the exact set can differ between files and accounts. A file that covers the usual needs has these columns for each line of each sale:
- A sales receipt number, repeated on every line of the same sale.
- The sale date, in one format throughout the file.
- The customer name, matching the QuickBooks customer exactly, or a single walk-in customer for anonymous sales.
- The product or service, matching an existing item.
- A description, quantity and rate, or simply an amount.
- The deposit-to account, normally Undeposited Funds.
A sale with two items is two rows with the same receipt number. Spell customer and item names exactly as they appear in QuickBooks, because a near match can create a new customer or fall back to a generic item.
Splitting a big export
A busy month from a payment app can run to thousands of rows. Split it into files under the row limit, for example one file per week, and name them by date range. Import one, check the totals, then move to the next. If one file goes wrong you only need to repair a week, not the month.
Card fees, refunds and tips inside a sales import
Card fees, refunds and tips are the amounts that make a sales import disagree with the bank. Record the full sale as income, record the card fee as an expense, record refunds as refund receipts or negative lines in the summary, and record tips owed to staff as a liability. Then the deposit equals sales minus fees minus refunds.
Take the bakery's card takings of 1,104.50. Suppose the card processor kept 2.9% plus a small per-transaction charge, which comes to 38.21 in this example, and one customer was refunded 12.00 that day. The deposit that reaches the bank is 1,104.50 minus 38.21 minus 12.00, which is 1,054.29.
If you import only the net deposit of 1,054.29 as sales, your income looks 38.21 smaller than it was, and you have no record of the fees you paid or the refund you gave. Both matter: the fees are a business cost you want to see, and the gross figure is what your till actually sold.
Where to put each amount
- Card fees: an expense line on the deposit, or a separate expense, booked to a merchant fees account.
- Refunds: a refund receipt in QuickBooks, or a negative line in the daily summary if you use one.
- Tips: a liability account such as Tips payable, cleared when you pay the staff.
- Gift cards: a liability when sold, moved to income when redeemed.
Marketplace sales follow the same logic
Marketplaces deduct far more than card fees: selling fees, shipping labels, ads and holds. The arithmetic is the same but with more lines, and importing Amazon sales into QuickBooks walks through a settlement report line by line.
How do imported sales meet the bank deposit?
Imported sales meet the bank deposit through Undeposited Funds. Each sales receipt or daily summary is saved to Undeposited Funds, and when the money arrives you record one bank deposit that pulls together the matching receipts and subtracts the fees. That deposit then matches the single line on your bank statement.
Intuit's article on the Undeposited Funds account calls it a temporary holding place for payments until you record a formal deposit. Its example is five 100.00 checks that the bank shows as one 500.00 deposit: the five records are combined in QuickBooks to match the one bank line.
The bakery's deposit, step by step
- Save Tuesday's card summary to Undeposited Funds: 1,104.50 of card sales, with the 12.00 refund as a negative line, so the receipt totals 1,092.50.
- When Wednesday's bank line of 1,054.29 appears, open a new bank deposit.
- Tick the 1,092.50 receipt.
- Add a line for the card fee of 38.21, as a negative amount to the merchant fees account.
- Check the deposit total reads 1,054.29, then save.
When the bank line comes in through the feed or an upload, QuickBooks offers the deposit as a match. Intuit's article on matching bank transactions in QuickBooks Online lists grouped payments and fees among the reasons a match is not suggested. Building the deposit first, with the fee inside it, is how you remove both reasons.
Getting the bank lines in
Matching needs the bank lines in QuickBooks. A bank feed brings them in automatically. If your bank only gives you a PDF statement, it needs converting into a CSV or QBO file first; SimpleBankConvert is being built to make that file from the PDF, laid out for the QuickBooks Online bank upload, so the deposits arrive ready to pair with the receipts you imported.
When a sales import is the wrong tool
A sales import is the wrong tool when the sale has not been paid yet, when a connected app already posts your sales, or when you sell to a few customers on credit. Unpaid sales belong on invoices. Sales an app already sends would be counted twice. And a few large sales are quicker to type than to format.
Unpaid sales and orders
A sales receipt says the customer has paid. If they will pay later, the record should be an invoice, so the amount shows in what customers owe you. An order that has not shipped yet is earlier still. The post on sales orders in QuickBooks covers how an order is recorded before it becomes an invoice.
Two routes posting the same sales
Many point-of-sale and online store systems offer a QuickBooks connection that posts sales automatically. If yours is switched on, do not also import the same days by spreadsheet. Pick one route per sales channel and switch the other off. If you are unsure, search QuickBooks for one known day's total before importing anything.
Not using QuickBooks at all
The same question of totals versus detail applies in other accounting software, and so does the deposit step. If your books are in Zoho, the bank side of the routine is covered in importing a bank statement into Zoho Books.
A last check each month
At month end, add up the daily totals from your till or payment app reports and compare them with the sales income in QuickBooks for the month. Then check that Undeposited Funds holds only the takings still on their way to the bank. A balance that keeps growing in Undeposited Funds means some deposits were categorized as new income instead of being matched, and those days are counted twice.