english logo english logo english logo english logo english logo

Content on this page requires a newer version of Adobe Flash Player.

Get Adobe Flash player

Entering a Daily Sales Summary into QuickBooks

If you choose to not integrate your web store into your QuickBooks where it will enter each sale that gets made Into QuickBooks for you, you may be interested in entering in all the daily sales from the web store as a summary in QuickBooks.  It would be very tedious to enter in each sale individually manually, so most people opt for one Daily Sales Summary.  To accomplish this:

  2. In the Customer:Job drop down window select “Daily Sales Summary”(may need to “Create New”, or type name and choose to “Quick Add”).
  3. Enter each item and quantity sold that day, or add the total amounts broken down into categories that are meaningful to your business.


If all your sales are paid by the same payment method (for example, cash), or if you do not need to separate payments on your deposit by type, decide which deposit method you want to use and select it on the sales summary entry in the Payment Method field.

If you receive payments by various methods and need to separate the types on the deposit (for example, cash, check, Visa, MasterCard, or American Express), you can create a payment item for each payment type, and use these items to track the daily amounts received.

The payment items are entered on the sales summary form, and are subtracted from the total value, leaving the sales entry balance as zero. The payment amounts are then either deposited directly to an account, or grouped with other funds to be deposited, depending on how the payment item is created.

To create a payment item:

  1. From the Lists menu, choose Item List.
  2. Click New from the Item drop down window in lower left corner.
  3. From the Type field of the New Item window, choose Payment.
  4. Enter a name in the Item Name/Number field, indicating the payment method as part of the name (such as Check, Cash, Visa or MasterCard).
  5. Enter a Description to appear on each cash sales summary form.
  6. Select a Payment Method. This allows you to group the money you receive by payment method when you deposit it (Checks with Checks, American Express charges together, and so on).
  7. Choose the Deposit Method for this payment item: Group with other Undeposited Funds or Deposit To.
  8. Click Next to create another item, or click OK to close the window.

To enter a payment item on the sales summary form:

  1. Beneath the sales information, enter a payment item.
  2. Enter the amount received for this type of payment. QuickBooks makes the amount negative.
  3. Enter the next payment item and amount, and repeat until the balance of the entry is zero.

    Note: If you have entered all the payments and the balance is not zero, you have an “overage” or a “shortage.” This balance is often handled by entering another line item on the sales summary (using an item that tracks to a specific overages/shortages account) with a positive or negative amount to make the total balance equal zero.
  4. Click Save & Close.

 (If you have trouble seeing the image, double click it for a larger view.)

This entry was posted in Current Tips and Tricks and tagged . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Spam protection by WP Captcha-Free   -   Income Tax Preparation Services from Presti & Naegele