Skip to content

Recording Cash Sales through Enter Sales Receipt Module into QuickBooks

Recording Cash Sales through Enter Sales Receipt Module into QuickBooks

Sales that are conducted in cash satisfy the buyer’s financial obligation immediately. Money orders, cheques, credit cards, notes, and coins are all regarded as forms of payment for cash sales. The necessity for these sellers to give a customer credit is removed in a cash transaction. A bad debt is therefore not a possibility.

Sales receipts are a typical feature of conducting business. In fact, they are so commonplace that if you work in retail, you might consider them to be taken for granted. But when you’re running a business, it’s critical to pay close attention to your receipts. Your business accounting may be impacted by the data they contain, how you create and issue them, and other factors. You can keep track of your financial records and adhere to Canada Revenue Agency (CRA) tax regulations by using an efficient receipt creation and management system.

Creating Sales Receipts in QuickBooks Online

From any internet-enabled device, QuickBooks Online gives you the ability to create and email sales receipts. This implies that regardless of whether they are in the office or the field, your employees can instantly generate and send receipts. You can also modify the receipt using this straightforward, user-friendly feature to fit the products and services offered by your business.

In QuickBooks, creating a receipt is a quick and simple process. Open the plus sign menu after logging into your QuickBooks account, then select Customers. An empty form will appear after selecting Sales Receipt. From there, you can enter the client’s name or company name; keep in mind that you can save the client for later. You could also enter “Services Rendered” in the Name field as an alternative. Enter the items you sold after that. If you only carry a limited number of products, you can simply save each one as an inventory listing. Your saved products can automatically fill out the line item field when you create a receipt. When you sell the same things frequently, this saves time.

Adding details about the good or service, like the ID number or a description, is simple when adding new items in QuickBooks. The per-unit costs are then added. According to your quantities and prices, the form automatically calculates a subtotal. The sales tax is added when necessary by QuickBooks because it is aware of your location and industry.

You have a few options for moving forward after your receipt is prepared. With the help of the print preview feature, you can view the completed document and identify any errors or changes. Once satisfied, just save the receipt to the database. After that, you can print or email the document to the client. The fact that QuickBooks is integrated with your accounting system is one of the main benefits of using a receipt generator. Your bookkeeping can be simplified as a result. You can choose to make the receipt an account payable or an income account when you create it. You don’t need to enter the funds separately because they are then automatically added to your financial records.

How to enter daily sales totals in QuickBooks Online?

If you utilize a different Point of Sale system, you can enter a single sales receipt to report the overall daily sales in QuickBooks. Or if you merely fail to send invoices to clients. You can do this to save time while maintaining the accuracy of your income reports.

Here is a step-by-step instruction manual to get you going.

Step 1: Create a customer for daily sales in step one.

This customer account will only be used on your “end of day” sales receipt.

  • Select Customers from Get paid & pay or Sales after going there (Take me there).
  • Choose New client.
  • Specify “Daily Sales.”
  • Choose Save.

Step 2: Create accounts for everyday sales

Ensure that the Daily Sales accounts are positioned correctly. Accurate income reporting can be greatly aided by doing this.

How to create daily sales accounts

  • Pick the Gear button from the Toolbar.
  • Choose Chart of Accounts under Your Company.
  • At the top right, click New.

Step 3: Prepare products for daily sales

To keep your items organized, create a “Daily Sales” category:

  • Pick the Gear button from the Toolbar.
  • Select All Lists under Lists.
  • deciding on Product Categories.
  • At the top right, click New Category.
  • Called “Daily Sales,” the new category.
  • Click Save.

The following items come after the Category has been set up:

  • Pick the Gear button from the Toolbar.
  • Select Products and Services under Lists.
  • At the top right, click New.
  • Set up the following. Please remember to choose Daily Sales as the Category for each item.

Step 4: Create a template for daily sales.

This template will be used each time you need to keep track of daily total sales.

  • On the Toolbar, choose the Gear icon.
  • Select Recurring Transactions from the list.
  • Click New in the top right corner.
  • Select Sales Receipt from the dropdown menu for the Transaction Type.
  • Make sure the Type is Unscheduled and give your template the name “Daily Sales.”
  • Decide on Daily Sales as the client.
  • Choose the following choices from the Product/Service column:
    • Daily Sales: Daily Sales Income
    • Daily Sales: Cash
    • Daily Sales: Check
    • Daily Sales: Visa/Mastercard
    • Daily Sales: American Express
    • Daily Sales: Overage/Underage
    • Daily Sales: Discover
    • Select Save template.

QuickBooks receipts save time if your business receives a lot of repeat business. Information about a customer is saved in the cloud once it has been entered. When you create a receipt later, you can have their information automatically fill the form. Even if the sale you’re logging is a one-time event, the saved copy may be helpful in the future if you need to review the transaction. QuickBooks also assists in ensuring that your critical data is safe and nearly impossible to lose by storing your sales records in the cloud. All records also include digital timestamps, which produce an unchangeable paper trail that the CRA accepts as proof of sales.

Usage of Sales Receipt Module

At the start of their entrepreneurship, a lot of modern business owners find themselves surrounded by complex accounting jargon. Business owners have a variety of administrative responsibilities due to various legal requirements. The two most important financial records in any business partnership are invoices and sales receipts. Each detail about your business, your products, and their prices are contained in the first. Most frequently, the latter are referred to as discounted invoices.

The method of handling sales receipts is overly simplistic, though. For the purpose of educating you on when and how to use sales receipts, we’ll go into more detail about them in this article.

Features of sales receipts for production:

Sales receipts are equally useful for purchases made domestically and abroad. The fact that these forms are fully valid reports that can take the place of demanding invoices is their main advantage.

Consequently, you can sell more goods in a given period of time. You can boost production if items from your stock are sold more quickly.

The process is also two-way, which is the cherry on top. One the one hand, buyers can place more orders with suppliers for goods. Suppliers, on the other hand, are able to produce and offer more products to their clients.

Therefore, reducing administrative details like detailed invoices benefits the economy by increasing productivity and the volume of business deals.

Sales receipts for effective business cooperation:

How do you tell your clients what they owe you and for how much money? These days, with the advent of e-commerce and merchant accounts, your customers may give you their credit card information over the phone or online. Invoices may also be sent following a sale, and you may then receive checks or account numbers in the mail. Both the invoice creation and payment recording can be facilitated by QuickBooks.

You can also use sales receipts as sales documents in specific circumstances. When customers pay you in full at the same time they receive goods or services, you are probably most likely to use one of these.

Providing access to sales receipts for entrepreneurs demonstrates how entrepreneurs can gain from lax economic regulations. Additionally, the government will receive more tax revenue from businesses with higher revenues.

However, governments’ excessive regulation of the economy and business transactions is the biggest issue facing many communities. It’s harder for business owners to organize their operations and make ends meet when there are too many regulations in each market. As a result, business owners and managers should insist on implementing streamlined administrative procedures. Invoices can still not entirely be replaced by sales receipts. In all honesty, raising the minimum price for sales invoices may also encourage some unintended tax evasions.

However, in order to find the most practical answers for a more sophisticated use of sales receipts, the government and business community should collaborate. They could increase both the general effectiveness of the local economy and (inter)national business transactions if they are successful in coming up with novel solutions for these problems.

The bottom line is that more space for less complicated financial documents, like sales receipts, would be advantageous for the entire community. The price threshold rules should be followed when using sales receipts up until that point to make the most of them for your company.

Customizing Sales Receipts

Sales receipts can be customized using tools provided by QuickBooks:

The fields that small businesses use the most frequently are included in QuickBooks’ forms. However, you can change them in a variety of ways to fit the needs of your business. Open the Sales Receipt window and select the Formatting menu to customize a sales receipt. the Manage Templates option.

To ensure that you always have access to the original sales receipt, you should make a copy of it. In the lower left corner, click the Copy button. In the list of templates, “Copy of Custom Sales Receipt” can be found. Click in the field next to “Template Name” in the Preview pane on the right and, if desired, change the default name to one that is more illustrative. Select OK. Opens the Basic Customization window. On the screen’s bottom, click Additional Customization. You’ll see a window similar to the one in the preceding picture. Toggle to the Columns tab. All the columns that can be put in your sales receipt’s body are shown in the list on the left. Select the columns that should appear on your QuickBooks screen and on the customer’s copy by clicking in the boxes beneath Screen and Print. To indicate which column will come first, second, etc., change the numbers in the Order column.

You have a lot more customization options with QuickBooks forms. There are additional circumstances in which you might want to provide a sales receipt. We’ve only been able to briefly discuss both subjects here, but we’d be happy to set up a meeting with you to go over these QuickBooks features.

Selling of Inventory Items and its impact on Profit & Loss Account & Balance Sheet

The purchase of inventory will have an impact on your balance sheet, a financial statement that gives a quick overview of the value of your company based on its assets and liabilities. You enter the value of the inventory, and depending on how you bought the goods, the corresponding entry is either cash or accounts payable. Your income or profit and loss statement have not been changed yet.

You eventually use the items in your inventory to fulfil orders from clients. Sales are recorded in an income statement account, and cash or accounts receivable—both balance sheet accounts—are used to offset sales. Your profits are inflated unless the necessary adjustments are made because you used inventory from a balance sheet account and recorded sales on your income statement. The value of the items sold must be deducted from your inventory, and an adjustment must be made to a cost-of-goods-sold account. Your cost-of-goods-sold account is an account on your income statement. Your profit and loss have now changed.

Understanding Undeposited Fund Account and its functionality

Effects on the Balance Sheet:

  • Your inventory-enabled Product/Service items’ associated Inventory Asset accounts are displayed on the Balance Sheet.
  • These are categorized under Other Current Assets.
  • The asset balances display the price of your current (unsold) inventory.
  • If your company runs on a cash basis, you’ll need to customize the Balance Sheet report and switch the accounting method to accrual in order to see these balances.

Impacts on the profit and loss statement:

  • The Cost of Goods Sold (COGS) accounts linked to your inventory-enabled Product/Service items are displayed in the Profit & Loss report along with the Sales of Product Income accounts.
  • The report’s COGS accounts are shown in a separate section between the Income and Expense sections.
  • The Gross Profit line displays the difference between your Total Income and Total COGS amounts.
  • You must customize the Profit & Loss report and switch the accounting method to Accrual if your company uses a cash basis in order to see the correct Gross Profit figure.

Unlinking Undeposited fund account with Sales Receipt Transaction

The account for undeposited funds is intended to be used only temporarily. It’s exclusive to QuickBooks Online and its main objective is to simplify bank reconciliations. Typically, the bank will combine all the separate checks you deposit in one trip into one transaction. In other words, the information on your bank statement and your itemized bank deposit slip are not the same.

With the help of the special account, you can group together various transactions into a single record in the same way that your bank has done.

How Can Undeposited Funds Be Cleared?

By completing a bank reconciliation, this account is intended to be cleared. the following steps:

  • Deposit the necessary funds at your actual bank.
  • Wait for the cleared funds to appear on the bank statement.
  • To combine transactions in your undeposited funds account, use the bank deposit feature.
  • The undeposited customer payments you want to combine are marked with checkboxes.
  • Verify that the sum is the same as what is shown on the bank statement.
  • Following an incorrect workflow in QuickBooks frequently results in a balance.
  • The balance, however, must always be zero.

Many inexperienced users are unaware that the following circumstances will automatically deposit funds to this special account:

  • As soon as you get invoice payments
  • When a payment item is used on an invoice (such as when you receive a deposit or partial payment)
  • Once a sales receipt is entered

You’ll probably discover the transaction in the undeposited funds account in the cases mentioned above. Therefore, ensure that the bank reconciliation is correctly carried out to eliminate the balance.

Dummy Account Method

Here is an alternative approach to removing old transactions from your undeposited account if you can’t match them to a bank transaction:

  • Create a new checking account under your Chart of Accounts with a fake-sounding name so that it cannot be mistaken for an actual account.
  • Save and exit.
  • Navigate to the Bank Deposit window.
  • Pick the fictitious bank account you just created from the drop-down menu labeled Choose Account.
  • The old customer payments that are still visible in the undeposited funds account should be chosen.
  • Save and exit.

Your undeposited funds account now has a balance of 0, but you also have a dummy account that needs to be cleared. Then do these things.

  • To create an expense transaction, click on your expense window.
  • Select a regular income account to which you can transfer funds from your fictitious account.
  • Send the entire balance.
  • Your fictitious account balance is now also zero.

Overview of Profit & Loss reports

Your profit and loss report cannot be directly filtered by bank account in QuickBooks Online. However, you can obtain essentially the same information by using Location tracking in QuickBooks Online Plus and Advanced.

You can configure a location for each bank account if location tracking is enabled. Put each transaction you enter in one of those places or bank accounts. To view the profit and loss for each bank account, filter the Profit and Loss report by location.

Step 1: Enable location tracking

You must enable the Location tracking feature before you can configure locations for your bank accounts.

  • Go to Settings.
  • Select Account and settings.
  • Select Advanced.
  • To access the fields, choose Edit in the Categories section.
  • Track locations should be enabled.
  • Use the options in the Location label dropdown list to (optionally) define a name for the field where you choose a location. The name of the field defaults to Location if you do not choose an option.
  • Then click Done after selecting Save.

Step 2: Establishing the locations of bank accounts

You can give each of your bank accounts a location once location tracking is enabled so that you can track it.

  • Enter Settings.
  • Select All Lists under Lists.
  • Choose Locations from the Lists screen.
  • Pick New.
  • In the Name field of the Location Information dialog, type the name of the bank account.
  • Click Save. For each bank, repeat these steps.

Step 3: Assign transactions to locations

Once your banks are set up, whenever you open an Income or Expense transaction, a Location field dropdown list will appear. Choose the desired location from the list for each transaction.

It should be noted that locations cannot be assigned to payment transactions. The location you specified on the invoice when you created it receives payments automatically. Transfer destinations cannot be specified.

Step 4: Run your Profit and Loss by Location report.

You can add a Location column to your Profit and Loss report to make a report that lists each bank account separately after setting up your bank accounts as locations and associating a bank account with each of your transactions.

  • Alternatively, go to Reports by choosing Business overview > Reports. 
  • Choosing the Profit and Loss report
  • Decide on Customize.
  • To open the section, choose Rows/Columns.
  • Choose Locations from the Columns dropdown menu. Choose the label you applied if one was applied to the field.
  • Decide on Run report.
  • (Optional) For this report to be saved, choose Save customization. On the Reports page’s Custom Reports tab, you can access the report later.

Overview of Sales Reports

Report on monthly sales

You can learn about the current customer mood and the overall performance of your business from a monthly update on your sales.

Follow the easy instructions below to run this QuickBooks Sales Report:

  • Step 1: From the left-hand menu, select Reports.
  • Step 2: Enter sales in the field labelled “Report By Name.”
  • Step 3: After seeing a list of reports, choose the one you require.
  • Step 4: Select This Month as the Report Period in the top left corner.
  • Step 5. Select Run Report.

Report on Gross Sales

If you work in the customer retail industry, this QuickBooks Sales Report is particularly crucial. It aids in calculating the Total Turnover and tracking the expansion of the Business.

You can produce this report by using:

  • Navigate Reports on the left side by navigating.
  • Sales by Product should be entered in the search box, and Sales By Product/Service should be chosen from the drop-down menu.
  • Pick the reporting period.
  • Click Run Report.

Recording Cash Services by entering Sales Receipt Module

It’s time to learn to account for cash receipts now that you have some background knowledge on them.

To properly account for cash receipts in your small business books, follow these steps:

  • Selling for cash
  • Note the cash payment transaction.
  • Making the sales entry

1. Conduct a sale in cash

Making a cash sale is necessary before you can record cash receipts. Keep all receipts when conducting a cash transaction. The sales receipts serve as documentary evidence of the transaction.

The customer’s name, the date of the transaction, an itemized list of the goods or services sold, the price for each item, the total amount of the sale, and the sales tax are typically included in sales receipts (if applicable).

The check number should be listed alongside the sales receipt if you accept checks. Use a storage system to arrange business receipts so that your books are as accurate as possible (e.g., filing cabinets or computer).

2. Record the receipt of cash transactions.

A chronological list of your cash transactions should be kept in your cash receipts journal. Record each cash transaction in your cash receipts journal using your sales receipts.

The sales tax you gathered shouldn’t be entered in the cash receipts journal. Instead, you must note this in the sales journal.

3. Enter the sales information.

Cash sales should be entered as a credit in your sales journal and as a debit in your cash receipts journal. Remember that if you offer store credit or if customers use a variety of payment methods, your entries will change (e.g., part cash and credit).

4. Procedure for cash receipts

You need to have a cash receipts procedure in place if you want to keep your books accurate. Your cash receipts process will assist you in organizing your total cash receipts, preventing accounting mistakes, and ensuring accurate transaction recording.

Your cash receipts policy should resemble something like this:

  • Sort and arrange business receipts
  • Keep track of your cash and check transactions.
  • Keep track of additional incoming cash (if applicable)
  • Make deposits in money

General FAQs:

  1. What does QuickBooks’ sales by item summary mean?

    You can view both summary and in-depth information about the sales of each of your products and services using the QuickBooks Sales by Item Reports. You can find out how many of each good or service you’ve sold, the total amount of sales, and the profitability of each one in the Sales by Item Summary.

  2. How do I view the various report types in QuickBooks?

    To switch between the following reports: Profit & Loss, Balance Sheet, Invoices by Status, or Invoices by Month, select the drop-down arrow next to the title. To view your income, expense, and gross profit breakdowns, select the bulleted list icon.

Speak to A Specialist about QuickBooks Software

Headache🥺. Huh, Save time & money with QuickBooks Support 24×7 @ +1/, we provide assistance to those who face problems while using QuickBooks (Support all U.S. & Canada Editions)

--- Support - We provide solutions for the following QuickBooks (Pro, Premier, Accountant, Enterprise, Payroll, Cloud) ---

  • Error Support
  • Data Import
  • Data Conversion
  • Payment Solutions
  • Upgradation
  • Payroll Support
  • Data Export
  • Software Integration
  • QuickBooks Printer Support
  • Complete QuickBooks Solutions
  • Tax-Related Issues
  • Data Damage Recovery
  • Installation, Activation Help
  • QuickBooks Windows Support

Disclaimer : We are a third party agency working on providing authentic support and full fledged services for for accounting software QuickBooks 2018 version. It is one of… Read more