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.
What do I do when the drawer does not balance?
Set up a Cash Over and Short account and stop trying to make the count agree with the register. A drawer that is a few dollars off most days is normal in any cash business, and forcing the numbers to match hides the one day that actually matters.
Create an account called Cash Over and Short. Most US small businesses set it up as an expense account, since over a full year the drawer usually runs short. If yours reliably runs long, an other income account works just as well, and either choice is acceptable as long as you are consistent about it. When you record the day, enter the counted cash as the deposit and let the difference fall into Cash Over and Short: a $2.40 shortage is a $2.40 debit to that account, a $1.15 overage is a credit.
The value of doing it this way shows up over months, not days. Run a report on that one account by period and you have an honest picture of drawer accuracy. Random noise around zero is a healthy business. A steady one-sided drift, or a single large variance on one shift, is a conversation to have while you can still remember the day, and it is the sort of thing that never surfaces at all when the count is quietly forced to match.
How do I record a day of sales from a POS Z-report?
Enter one summary transaction per day rather than a QuickBooks entry per customer. This is the standard method for restaurants, retail, salons and food trucks, and it is why a busy shop can keep clean books without drowning in data entry.
Take the daily close report from your point of sale, sometimes called the Z-report or Z-out, and record it as a single sales receipt or journal entry dated that day. Break it out into the lines your chart of accounts needs: gross sales by category, sales tax collected as a liability rather than income, tips as a liability if they are paid out to staff later, discounts and comps, then the payment side split between cash counted, card settlements and any gift card redemptions.
Two details keep this reconcilable. First, card settlements usually land in the bank a day or two later and often net of processor fees, so post the gross amount and record the fee separately instead of letting the deposit define the sale. Second, the cash line should be the amount you actually counted and are actually depositing, with any difference sitting in Cash Over and Short. Do both and each day's summary ties cleanly to a specific bank deposit, which is the whole point when you get to reconciliation.
When do I have to file Form 8300 for a large cash payment?
File IRS Form 8300 within 15 days when your business receives more than $10,000 in cash in a single transaction or in related transactions. This is a filing obligation separate from your tax return, and it applies to any trade or business, not only to banks and car dealers.
The definition of cash is narrower than people assume and wider in one direction than they expect. It covers US and foreign currency, and it also covers cashier's checks, bank drafts, traveler's checks and money orders with a face amount of $10,000 or less when received in what the IRS calls a designated reporting transaction. Personal checks are not cash for this purpose, whatever the amount. Related transactions matter too: several payments from the same buyer inside a 12 month period that add up past $10,000 can trigger the requirement even though no single payment did.
The mechanics: file within 15 days of the transaction, and if the fifteenth day falls on a weekend or holiday, the next business day. Businesses already required to e-file 10 or more information returns in a year have had to e-file Form 8300 electronically since 1 January 2024; others can still file on paper. You also have to give each person named on the form a written statement by 31 January of the following year. Penalties for intentional disregard are severe, starting in the tens of thousands of dollars per return for returns due in 2026. Verify the current thresholds and penalty figures on IRS.gov, since they are indexed and move.
None of this changes how you record the sale in QuickBooks. Record the income the way you always would, and treat the filing as a separate compliance step. It is worth flagging the transaction in the memo field so the entry and the filing can be tied together a year later when somebody asks.
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.
Which cash situation you have, and how each one posts
Most confusion here comes from treating every cash movement the same way. They are not the same. Money taken from customers, money moved into a till to make change, and money spent out of an envelope are three different transactions with three different treatments, and mixing them is what produces an undeposited funds balance nobody can explain.
| Situation | Record it as | Debit | Credit | Watch out for |
|---|---|---|---|---|
| Cash taken from customers during the day | Sales receipt or daily sales summary | Undeposited funds | Income, plus sales tax payable | Recording per customer when a daily total is enough |
| Cash and checks taken to the bank | Bank deposit | Bank account | Undeposited funds | Group the deposit exactly as the bank shows it |
| Moving cash into a petty cash tin | Transfer | Petty cash | Bank account | Booking it as an expense on the way in |
| Spending from the petty cash tin | Expense | The relevant expense account | Petty cash | Waiting for a receipt that never arrives |
| Replenishing the tin back to its float | Expense entry then transfer | Expenses, then petty cash | Petty cash, then bank | Recording only the top up and losing the spending |
| Till comes up short or over | Cash over and short | Cash over and short if short | Cash over and short if over | Forcing the deposit to agree instead |
| Owner takes cash from the till | Owner draw | Owner draw or distributions | Undeposited funds or petty cash | Treating it as a business expense |
Read down the third and fourth columns and the pattern is clear: cash coming in from customers is income, cash moving between your own containers is a transfer, and only cash leaving to a third party is an expense. Almost every messy cash file breaks one of those three rules.
Why petty cash so often ends up with an impossible balance
The classic failure is recording the replenishment and nothing else. Someone withdraws $200 to refill the tin and codes it to office supplies. That looks harmless. But the actual spending, which might have been postage, parking and a client lunch, was never recorded, the petty cash account never moves, and the expense sits in the wrong category. Do that monthly and the tin has a book balance of zero while genuinely holding cash, or a growing balance while sitting empty.
The fix is to treat the tin as a real account with a fixed float. Set it at a round number, say $300. Record every disbursement out of it as an expense against the petty cash account, using the receipts. When you top it back up, the withdrawal is a transfer from the bank into petty cash, never an expense. At any moment the cash in the tin plus the receipts not yet entered should equal the float, and that is a check you can run in seconds.
What to do when the counted cash does not agree
Use a cash over and short account and post the difference to it. Do not adjust the sales figure to force agreement, because that misstates revenue and, where sales tax applies, misstates what you owe. A small balance in cash over and short across a year is normal in any business handling notes and coins. A large or one directional balance is telling you something about the process, most often that sales are being rung up inaccurately or that the float is being used for purchases without receipts.
If cash receipts are being reconstructed later from the deposits alone, the numbers will only ever be as good as the bank record, so getting the deposit history in cleanly matters. Where the bank feed does not reach back far enough, you can upload transactions to QuickBooks Online from the statements for the earlier periods and work from actual deposit amounts rather than estimates.
Skip the manual entry
Upload a PDF bank statement and get a QBO or IIF file ready to import into QuickBooks.
Convert a Statement Free