How to Record Cash Sales and Petty Cash in QuickBooks
Convert a PDF bank statement to a QuickBooks file
Drop in a PDF statement and get a QBO (Web Connect) or IIF file you can import into QuickBooks Online or Desktop.
To record cash sales in QuickBooks, enter the total cash taken from your point of sale report as income into an Undeposited Funds or Cash on Hand account, then record the bank deposit as a transfer out of that account into checking. Cash you spend straight from the till is recorded as an expense paid from Cash on Hand. This keeps your revenue complete and your deposits reconciling, which a bank feed alone can never do because it only ever sees the cash you deposited.
The deposit side is the part your bank statement proves. If your statements are not in QuickBooks yet, convert the PDF bank statement to QuickBooks with the tool at the top of this page, so every cash deposit is in the books with its real date and amount and you can reconcile it against what the register says you took in.
Why is cash the hardest money to track in QuickBooks?
Because a bank feed only shows the cash you deposited, never the cash you took in. If you rang up $900 in cash sales, paid a $60 parking fee and $140 for a supply run out of the drawer, and deposited $700, the bank feed shows $700. Book only that, and you have understated revenue by $200 and lost two deductions. The gap is invisible: nothing in QuickBooks flags it, and the account still reconciles.
This is why cash-heavy businesses (food trucks, salons, laundromats, market vendors, small contractors) end up underreporting income and overpaying tax at the same time, which is an unusually bad trade. The fix is not complicated: record the gross cash, record what you spent from it, and treat the deposit as a movement between two accounts you own rather than as the sale itself.
How do I record cash sales in QuickBooks Online?
Use a Sales receipt for the day's or week's cash total from your point of sale report, and set the Deposit to field to Undeposited Funds. That records the income without pretending the money is in the bank yet. Then when the cash physically goes to the bank, select + New, Bank deposit, tick the sales receipt, and deposit it into checking on the date it actually landed.
Do not enter every individual cash sale. Enter one summary per day (or per shift) from the POS report. Detail below that level belongs in the POS, not in QuickBooks, and typing forty $8 sales by hand is how people give up on their books. The summary is what has to be right, because that is what your income statement and your tax return are built from.
How do I record cash sales in QuickBooks Desktop?
In Desktop the flow is the same: Customers, Enter Sales Receipts for the daily cash total, deposited to Undeposited Funds, then Banking, Make Deposits when the money reaches the bank. Desktop has always steered you toward Undeposited Funds, and that is the correct habit, because it separates the moment you earned the money from the moment it hit the account.
If you take a mix of cash and card in a day, record the cash total and the card total as separate lines. The card money arrives as a payout net of fees on a different date, so it has to be tracked on its own or the deposit will never match. That split is what makes daily reconciliation possible instead of a monthly guessing exercise.
What is Undeposited Funds and do I need it?
Undeposited Funds is a holding account for money you have received but not yet put in the bank. It exists so that a $700 deposit made up of three separate sales matches one $700 line on your bank statement instead of three lines that do not exist there. Without it, your deposits will not match the statement and reconciliation becomes painful.
You need it any time the money you receive is grouped before it reaches the bank, which is exactly what happens with cash. If a payment goes straight into the bank as its own line (an ACH from a client, for instance), skip Undeposited Funds and put it directly in checking. Using it for everything by reflex is the other way people get stuck, with a balance that never clears.
How do I set up a petty cash account in QuickBooks?
Create a new account of type Bank and name it Petty Cash or Cash on Hand. It behaves like any other bank account: money goes in, money goes out, and it has a balance you can count against the actual bills in the drawer. Fund it with a transfer from checking (the cash you withdrew to start the float), and that transfer is the opening entry.
When you spend from the drawer, record an Expense paid from the Petty Cash account, coded to whatever it was for. When you deposit leftover cash to the bank, record a transfer from Petty Cash to checking. At the end of the month, the balance in QuickBooks should equal the cash actually sitting in the drawer. If it does not, something was spent without being recorded, and that difference is the number to chase.
How do I record cash I spent straight from the drawer?
Record it as an expense paid from your Cash on Hand or Petty Cash account, not from checking, because the money never went through checking. A $140 supply run paid from the till is a supplies expense funded by cash. That single entry both takes the money out of your cash account and gives you the deduction you would otherwise have lost.
The discipline that makes this work is keeping the receipt. Cash spending with no receipt and no entry is money you paid tax on for nothing. Snap or file every slip on the day, and enter them weekly in a batch, coded from Petty Cash. It takes ten minutes and it is usually the single most profitable ten minutes in a cash business's week.
How do I reconcile cash sales against my bank statement?
Compare three numbers: total cash sales from the POS report, total cash spent from the drawer, and total cash deposited on the bank statement. Sales minus spending should equal deposits, plus or minus whatever float you left in the drawer. When those tie out, your cash is clean. When they do not, the difference is unrecorded spending, a miscounted drawer, or a deposit that has not cleared yet.
The bank statement is the only hard evidence in that equation, which is why getting it into QuickBooks accurately matters. Converting the PDF gives you every deposit with its true date and amount, so you are reconciling against the bank's record rather than against your own memory of what you took to the branch. Statements that come in some other format can be turned into a spreadsheet if you want to work the numbers outside QuickBooks first.
Do I have to report cash sales?
Yes. All business income is reportable regardless of how it was paid, and cash is no exception. The IRS does not treat undeposited cash as invisible, and a business whose reported revenue is far below what its costs and deposits imply is exactly the profile that draws attention. Recording cash properly is not just bookkeeping hygiene, it is the part of the return that has to be right.
The upside is that doing it correctly usually lowers your tax bill, not raises it, because the same discipline captures the cash expenses most owners forget. Complete records mean complete deductions. Half-recorded cash gives you the worst of both: the risk of underreported income and the certainty of overstated profit.
Get the deposit side right first
Everything above depends on your bank statements being in QuickBooks. Convert the PDF statements so every cash deposit is recorded with its real date and amount, then build the sales receipts and petty cash entries on top of them. That way the cash you say you took in and the cash the bank says you deposited can be compared honestly, and any gap becomes a thing you can find instead of a thing you tolerate.
If you are behind, start with catch-up bookkeeping from PDF bank statements, then categorize the imported transactions. For businesses that run heavily on cash and a mobile card reader, the workflow is laid out end to end on the PDF bank statement to QuickBooks for food trucks page.