cancel
Showing results for 
Search instead for 
Did you mean: 
sales-cookeville
Level 2

I import invoices from my service software and transactions from my bank. I have to link them. Some pay us CASH which we cannot deposit (online bank). How do we do that?

We have an LLC. So any money taken out of the biz checking is a distribution to partners. We keep the cash we collect for invoices since we cannot deposit it. How do I account for this cash?
3 Comments 3
KlentB
Moderator

I import invoices from my service software and transactions from my bank. I have to link them. Some pay us CASH which we cannot deposit (online bank). How do we do that?

I know a way how to handle that, sales-cookeville.

 

You can manually record those sales transactions in QuickBooks Online. You may use an invoice if the customer agrees to pay you later. I'll show you how:

 

  1. Click the + New button, then choose Invoice.
  2. From the Customer drop-down menu, select the appropriate customer. 
  3. Review the Invoice date and terms.
  4. From the Product/Service column, select a product or service.
  5. Enter a quantity, rate, and amount if needed.
  6. Click Save and Close, then receive the payment of the invoice.

If you were paid on the spot, you'll have to use a sales receipt. You can read this link to be guided in entering it: Create and send sales receipts in QuickBooks Online.

 

Additionally, I've included an article that will help you manage and track the status of sales transactions: View sales transactions.

 

Feel welcome to visit the Community again with any concerns or questions you may have. We're open 24/7 and always ready to help.

KlentB
Moderator

I import invoices from my service software and transactions from my bank. I have to link them. Some pay us CASH which we cannot deposit (online bank). How do we do that?

Hi sales-cookeville,

 

Hope you’re doing great. I wanted to see how everything is going about your concern. Were you able to enter the cash payments? Do you need any additional help or clarification? If you do, just let me know. I’d be happy to help you at anytime.

 

Looking forward to your reply. Have a pleasant day ahead!

ChristyYale
Level 3

I import invoices from my service software and transactions from my bank. I have to link them. Some pay us CASH which we cannot deposit (online bank). How do we do that?

I can offer 2 ways,

#1 for the sync/import into QB for sales receipts/recv payments have those post to undeposited funds account, then in the bank account feed you match those transactions to the payment/sales receipts from the undeposited funds account.  When all the bank acct feeds are posted the transactions left in undeposited funds "Should" be all the cash payments and then you make a "deposit" in QB to show all those cash payments are deposited into the petty cash account in QB.  

 

#2 for clients that refuse to use undeposited funds/do not want to match transactions I have them create a bank in QB named "Sales to account for" or "Collected Sales", then in the bank account feed post all deposits to that account (no matching), after all bank acct feeds are posted the remaining balance in the "Collected Sales" "Should" be only the cash payments and then just do one entry at day/week/month end to move that remaining balance to the petty cash account.  Keep in mind that at the end of a month the "Collected Sales" acct MAY have correct balance as payments/deposits may not actually go the real bank account until the 1st few days of the next month so this account may NOT to zero at the end of a week/month. This method does not have matching/checks & balancing built in like options #1 but sometimes this is the best way for clients to get it all posted WITHOUT the proper matching/checks and balances.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us