Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
It depends on how you will record it in QBO. You may create a montly sales receipt at the end of each month. Otherwise, you can migrate your invoice transaction data into QBO using an importer tool.
https://transactionpro.grsm.io/qbo
https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2
Just my 2 cents.
Hi simeontan,
You can record the monthly lump amount using the sales receipt if your customer pays immediately for the product or service or invoice if you need to bill your customer after the sale is made.
Here's how:
You can do the same thing once you want to enter an invoice: Create Invoices in QuickBooks Online.
Although sales receipts and invoices are used to track your daily sales, you can still follow the steps above to track it on a monthly lump amount.
You might want to run the Sales by Product/Services Detail report if you want to view the total sales: Run Reports.
Please touch base with me here for all of your QuickBooks needs, I'm always happy to help.
Is there another way to input the monthly sales at the end of the month. The monthly sales do not represent 1 customer but rather hundreds of customers. I was thinking if the total monthly amount can be added to an account that is labeled Sales with "income" attribute.
Hello NovemberSky,
Instead of creating individual sales receipts for each of your customers, we can record a bank deposit at the end of the month. Here's how to do it:
That's how to deposit your monthly sales.
Feel free to get back to us if you have additional queries.
One way to do is;
Create a contra account, which is kind of a clearing account.
As an example for Motel Revenue from room rent; create a Guest ledger account.
Then if you want to record monthly sales; you can do it by a J/E, in which to record amount of daily or monthly revenue/sales ;
Debit Guest Ledger Account
Credit Revenue
Then once you deposit cash and credit card amount in your bank account, you can do following J/E;
Debit Bank ( Whatever Deposit is )
Credit Guest Ledger Account
You can also debit the returns/refunds thru this clearing account.
Now, at the end of the year/month, either the account will show "0" or there may be some amount left in that clearing account, which would be your receivable or may be pending credit card balance.
Hope, this will help.
Hi Hina,
I am helping out a boutique hotel that is using QBO and trying to find information on how to enter advance payments. For example in January we only received advance deposits because due to covid we were shut down. Since the PMS does not interface with QBO what would be the best way to enter this information and track when they are used?
Thanks for joining the thread, cmanger.
You can record a retainer or deposit for the advanced payment made by the customer. This way, the transaction will show correctly on your financial reports.
To get started, you'll need to create a liability account to track the amount of the retainer received. Here's how:
Once done, create a retainer item you can use to receive the deposit or retainer. Let me show you how:
If you want the money from customer retainers and deposit in a separate trust account, you’ll need to set up a trust liability bank account. But if you don't, skip Step 3 from this article and proceed to Step 4-6: Record a retainer or deposit.
In case you'd want to browse some articles to know your financial status, you can see below links on how to generate:
I'm only a few clicks away if you should have questions about this or anything else. Take care.
Can I do this as an invoice due to the fact that the credit cards are deposited daily and with an sales receipt I can not apply multiple payments
Hello
Yes, you can do the retainer process if you choose to use an Invoice instead of a Sales Receipt. Just follow the steps on how to create a liability account and retainer item shared by my colleague MirriamM. Then, follow these steps on how to invoice the customer:
After invoicing, you can turn the retainers into credits on invoices. You can follow the steps provided in Step 5. Turn retainers into credits on invoices of this link: Record a retainer or deposit.
Let me know if you have other questions. Take care and have a great day!
Because we are now using a new system for our motorcycle shop sales, we want to enter a lump sum in QB to keep all records in one place for end of year reporting. It looks like a monthly "bank deposit" will work for our purpose. Because these entries are now a lump sum of all services and sales, and, If these sales/services are no longer tracked/ entered individually in QB, how do I now enter my monthly sales tax payments? Create a new expense account and track that way? I am getting my totals from the new system and just need to ender in QB for end of year as the new system does not track all expenses like utilities etc.
thank you for your help.
Can I do a monthly sales receipt but I have some A/R in my entry (from storage POS reporting).
We are accrual based and right now we are entering with journal entries and this makes our A/R balance on balance sheet negative as we do not have invoices?
Additionally can I enter taxes payable etc, refunds in the monthly sales receipt and would this still show in the profit and loss accrual
Allow me to assist you in recording the transactions you require in QuickBooks Online (QBO), lorenaemer.
Yes, you can create a monthly sales receipt in QBO by creating a recurring sales receipt (QBO). A recurring sales receipt charges a customer at predetermined intervals. Here's a link to an article with more information about setting up a recurring sales receipt in QuickBooks Online.
However, because you record an A/R transaction through journal entry without a payment, the Account Receivable A/R balance on the balance sheet will be negative. To resolve this, we can reverse a journal entry and remove it from the report. QuickBooks then generates a new journal entry to balance it. This is a record of the modification you made, with slightly different information:
Here's how:
For your last question, we can use a Refund receipt manually since recurring sales receipts are fully paid transactions. Let me show you how:
You can reference this article: Void or refund customer payments in QuickBooks Online. It also covers how to refund an invoice. In addition, I'd like you to read the following to learn more about how to enable automatic credit application to open customer balances and refund customer payments:
Please get back if you have other QuickBooks record-keeping concerns. I'm still here to help. Take care always, and more power to your institution!
No, I do not want to do recurring sales receipts. just monthly ones showing what we received as sales, what we have in A/R for that month, taxes, refunds. Like a journal entry but a sales receipt for all the movement in one month.
We are doing J/Es for this which seems to work well, except the negative AR balance, this is what I need to resolve.
I need a way to get all the monthly accounting movement in a sales receipt or JE. But as we do not create invoices A/R is negative. Can someone help?
Thank you,
Hello, lorenaemer.
I'm dropping by to help you record your transaction movement in QuickBooks, and make sure your AR balances are correct.
Journal entries are tricky to work with if you want to record all of your transactions in a single entry. This is usually used as a last resort to adjust some balances or to record certain entries that couldn't be entered using the standard transaction forms.
Furthermore, a sales receipt is used for income or money-in transactions. Using it to record your refunds, taxes, and other transaction movements could muddy up your books. It could also negatively affect your reports.
Moving on, an invoice is used for AR transactions. Since you don't use it, I would like to address the negative A/R balance from your journal entry.
Depending on the line items in your journal entry, we would want to review the amounts under the Debit and Credit columns. Change the amount placement to fix the negative balance for the AR account.
If you're still unsure how to make corrections, or how to record the movements with a journal entry, I would recommend consulting an accountant. They will guide you through the steps to ensure your entries are recorded properly.
I would also like to suggest a few things to ensure your entries are recorded properly.
We can record your taxes, refunds, and other sales entries using other forms. Recording these in a single monthly journal entry could negatively affect your balances and accounts.
Are you trying to record your payroll taxes and associated paychecks manually? We can take a look at this guide for details: Manually enter payroll paychecks in QuickBooks Online.
If this is related to sales taxes, we can use the Sales Tax feature instead.
For vendor and customer refunds, I'll add these articles for more information:
Would you like some assistance in reconciling your accounts after making those entries? Take a look at this guide if you need help in the future: Reconcile an account in QuickBooks Online.
Let me know if you have more questions about managing your entries in QuickBooks. If you need help running reports, or if you need to take care of your taxes, feel free to add the details to your reply. I'm here to help.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here