cancel
Showing results for 
Search instead for 
Did you mean: 
Hogwild3
Level 2

cash daily sales withdrawals

I am a Solo LLC Member using Quickbooks online.  I own a diner.  All sales from customers are deposited daily either by cash or credit card.  All transactions are downloaded automatically in Quickbooks through linked bank accounts.  So my dilemma I need to correct and learn properly.  I at times I take cash withdrawals before I make the day cash deposits. In Quickbook chart of accounts (Sales) it doesn't show full sales because of the cash withdrawals before deposit.  I created account Un-deposited Sales to account for all cash withdrawals used for owner expenses/pay or cost of goods.  Am I in the right thought process here.  How do I record theses now to show in my sales account to show full sales.  Please any step by step help is appreciated.

5 Comments 5
JasroV
QuickBooks Team

cash daily sales withdrawals

I appreciate you for sharing the details of your concern with us, @Hogwild3.

 

I can impart some insights on how to record your full sales in QuickBooks Online (QBO).

 

You can manually add a transaction to your sales account. Then, enter a note in the memo field stating what the transaction is for. This way, your account still shows the full amount of your sales. Let me show you how.

 

  1. Go to the Accounting menu and select Chart of accounts.
  2. Locate your sales account and click the View register link under the Action column.
  3. Click the Add journal entry, Add deposit or Add check drop-down arrow. 
  4. Select the transaction you want to add. 2.PNG
  5. In the Memo field, enter a note stating what the transaction is for (advanced withdrawal) and fill in the needed details. 2.PNG
  6. Once done, select Save.

 

You can also read through this link for more details: Manually add transactions to account registers in QuickBooks Online.

 

I'd also recommend working with your accountant for further advice about this matter. This way, we can ensure your account is well accounted for. If you don't have one, you can visit our ProAdvisor page and look for one from there.

 

To avoid any confusion in the future, you'll want to wait for the full amount to be deposited into your account before making some withdrawals. 

 

Moreover, I'm adding this article that can guide you on how to match your bank statement and QuickBooks efficiently: Reconcile an account in QuickBooks Online.

 

Have other questions about recording sales and withdrawals? You're always welcome to leave a reply in this thread. I'll be around to help you anytime. Have a good one and take care!

Hogwild3
Level 2

cash daily sales withdrawals

O.k.  So when I located sales in charts of account.  The only action available is run report. 

Charies_M
Moderator

cash daily sales withdrawals

Let me share some information about viewing the register in your account, Hogwild3

 

There are reasons why accounts in the Chart of Accounts (COA) only show the Run report option. Among these are the following:

  • The account is an Income or Expense account. ( Take note that the View register option is for the Balance Sheet accounts only like banks, assets, liabilities, and equities that run balances. While you can see the Run report for Income and Expense accounts that go to the Profit and Loss. 
  • The account doesn't have any balance.

In your case, since your referring to the Sales account which is under Income, the only available option is the Run report. This option lets you focus on a specific account instead of navigating the Reports menu.

 

Otherwise, you'll want to open the Profit and Loss report. Then, get the data you need for the business's finances whenever you want. Let me show you how:

  1. Go to the Reports menu.
  2. Use the Find report by name search bar to search for reports by name. You can also browse the list.
  3. Select the report to open it.
  4. If you change the dates or add filters to the report, select Run report to apply them.

Also, you can access all your pre-existing reports available within QBO through the help of these articles. This will help you know more about managing a wide range of reports in QBO without posting a question to the support page:

The Community is always open if you have other questions about running sales report. I'll be around to help. Wishing you a great day ahead!

Hogwild3
Level 2

cash daily sales withdrawals

So with the option only being run report how do I enter sales to compensate for the cash I withdrew from daily sales.  Right now quickbooks only shows the automatic deposits of sales that I make daily through connected bank account.  

MaryLandT
Moderator

cash daily sales withdrawals

I'm here to help record the sales to compensate the withdrawn cash, Hogwild3.

 

You can simply match the deposit of sales to the entry you've manually recorded on the Sales account. Doing this will prevent duplicates deposits on your bank register.

 

Here's how to match them:

 

  1. Find a downloaded transaction with the Match option in the Action column.
  2. Note the DateDescriptionPayee, and amount spent or received.
  3. Select the downloaded transaction to expand the view.
  4. Review the Matching records found in QuickBooks. This is the possible matching transaction you already entered in QuickBooks.
  5. Select the link next to each match to get more details.
  6. Make sure this is the correct match. In particular, review the Deposit toPayment method, and Bank account fields on forms for the existing transaction in QuickBooks.
  7. If this is the correct match, close the open transaction.
  8. Click ​Match​.

 

After you match or add downloaded transactions, they're recorded into QuickBooks. You can review your work and make sure everything is correct in the Categorized or Reviewed tab.

  1. Go to the Banking menu or Transactions menu
  2. Select the tile for the account you want to review.
  3. Go to the Categorized or Reviewed tab.
  4. Select the link in the Added or Matched column to review the transaction.

If you need to change or move a transaction to a different account, follow these steps to undo or unmatch it.

 

Let me know if you need anything else aside from recording your sales. I'm always around to help you.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up