• Skip to primary navigation
  • Skip to main content

QBGarage.com

The QuickBooks Specialists

  • Home
  • Blog
  • KnowledgeBase
  • Company
  • Show Search
Hide Search
You are here: Home / Archives for POS

POS

What Are the Procedures and Journal Entries To Record a Customer’s NSF or Bounced Check?

Chief Mechanic · September 4, 2010 ·

If you process enough transactions, sooner or later you’ll have to account for a returned check.  A check that is returned unpaid is given many labels (such as NSF or bounced check) but the accounting treatment is the same.

The procedures outlined below work effectively for POS users in both single stores and chains.  Activities such as receiving bank notices of fees and returned items typically take place at the headquarters rather than the store level, so these tasks are performed in QuickBooks financial software rather than POS.  However, in POS a payment can be accepted by clicking the Take Payment button at the bottom of the New Sales Receipt window.  This allows a customer to replace a returned check at any store in a chain.  When POS exchanges data with QuickBooks, the customer’s account will be updated.

For this example, let’s assume we received a returned check for $50 from a customer named Customer with check returned unpaid.  For handling the returned item, the bank charged a $25 fee, and we’ll only seek to recover from the customer the actual bank charges.  Rather than investigating each fee separately, some firms set a fixed fee to charge customers.  Hopefully, this customer will replace the unpaid check with another one, but we’ll need to record the activity in our cash account before that takes place.

Here are 2 methods to account for the returned check:

  1. create a new invoice to the customer for the amount of the returned check and fees your firm adds and a general journal entry for the expense of the fees the bank charged
  2. use 1 general journal entry for the entire process

Although the second method appears simpler, we recommend the first method because it preserves normal accounting procedures and provides a better paper trail by creating an invoice that can be sent to the customer to assist collecting the bounced check.

Method 1 – Re-invoice the Customer

Before accounting for this specific returned check, set up 2 new Other Charge Items on the Item List.  These Items will only be set up once.

The first other charge will be used to invoice the customer for the amount of the returned check.  At this point, it should be set to a $0.00 amount and have a Tax Code that is non-taxable.  An Item Name of Returned Check will serve as a reminder for how this charge will be used.  The Account must be set to the bank account into which the original returned check was deposited.  Later, the amount of the returned check will be entered when the customer is invoiced for the returned check, along with any applicable bank charges.  If you make deposits into multiple bank accounts, you’ll need a separate item for each bank account; in this case, include a reference to the bank account in the Item Name.

QuickBooks Premier 2009 New Item Returned Check

Next, add a second other charge for possible bank charges.  Like the other charge for the check amount itself, this charge should have a Tax Code that is on-taxable.  The amount can be set to either $0.00 (to indicate it varies depending on the situation) or a fixed fee representing a firm’s standard returned check fee.  An Item Name of Returned Check Bank Charges will be a good reminder of how this charge will be used.  The Account should be set to either an other income account or the expense account used for the original bank charge.  In this example, we created an other income account for reimbursed bank charges.

QuickBooks Premier 2009 New Item Returned Check

With the other charges properly set up, make a general journal entry for just the charge the bank deducted from your bank account.  To do that, click the Company->Make General Journal Entries… menu and enter the actual bank charge as a credit to the bank account and a debit to bank charges expenses as follows:

QuickBooks Premier 2009 GL Make General Journal Entries NSF 1

Next, click on the menu Customers->Create Invoices (or use the keyboard shortcut Ctrl + I) to invoice the customer for both the amount of the returned check and the fee charged by your firm.  In our example, the returned check was $50, and the bank charges are $25. 

Here’s the Create Invoices window:

QuickBooks Premier 2009 Create Invoices for Customer NSF Check

This invoice will be reflected on the customer’s account and will provide a document to present to the customer to collect payment.  Hopefully, the customer will replace the returned check.  At that point, use the normal procedure for recording a customer payment (Customers->Receive Payments) to record the replaced payment and depositing the funds (Banking->Make Deposits).

QuickBooks Premier 2009 Receive Payment for NSF Check

This approach has some important benefits.  It creates an invoice to help collect both the unpaid amount and the bank charges.  It also preserves the normal work flow for processing payments and making deposits.  It’s also the approach recommended by Intuit in the documentation for QuickBooks.

To review the debits and credits of each step, press the Journal button (or Ctrl + Y).  The general journal entry we first entered accounted for the actual bank charge.  When we recorded the invoice, we produced a debit to AR in the amount of $75, a credit to our bank account for the $50 check, and a credit to an other income account for $25.  The invoice in effect reduced the bank account by the amount of the returned check, so at this point, our bank balance is accurate.

Method 2 – Make 1 General Journal Entry

Some prefer to accomplish all of the above in just a single general journal entry.  To do that, click on the Company->Make General Journal Entries… menu and make these entries:

  1. AR: debit of $75 with the customer’s name entered in the Name field
  2. Bank account: credit of $50 to reduce the bank balance
  3. Bank account: credit of $25 to reduce the bank balance
  4. Bank service charges (expense): debit of $25
  5. Reimbursement income: credit of $25 to record the revenue (optionally enter the customer’s name in the Name field)

Ideally, although it’s not shown in the screen shot below, the debit to AR should be entered on the first line of the general journal entry.

QuickBooks Premier 2009 GL Make General Journal Entries NSF 2

The steps outlined above for recording a customer payment (Customers->Receive Payments) and depositing the funds (Banking->Make Deposits) are then used to complete the accounting when the customer replaces the returned check.

Vote This Post DownVote This Post Up (0 rating, 8 votes)
Loading...

What Versions of QuickBooks Financial Software Are Compatible With POS?

Chief Mechanic · August 30, 2010 ·

Point of Sale Basic 9.0 and Point of Sale Pro 9.0 are compatible with the following versions of QuickBooks financial software:

  • QuickBooks Pro and Premier 2007 to 2010
  • QuickBooks Enterprise Solutions 7.0 to 10.0

Point of Sale Basic 8.0 and Point of Sale Pro 8.0 are compatible with these versions of QuickBooks:

  • QuickBooks Pro and Premier 2006 to 2009
  • QuickBooks Enterprise Solutions 6.0 to 9.0

Generally speaking, a new version of POS will be compatible with the current version of QuickBooks and those from the prior 3 years.

Users of older versions of QuickBooks need to upgrade to integrate with POS.

If you need to upgrade, you can review detailed product comparisons as well as obtain discounts and free shipping by visiting the links on our Buy QuickBooks page.

What Versions of Point of Sale (POS) Are Compatible With Microsoft Windows Vista?

Chief Mechanic · August 30, 2010 ·

The following versions of QuickBooks Point of Sale (POS) are compatible with Microsoft Windows Vista:

  • QuickBooks POS Basic 6.0 and 9.0
  • QuickBooks POS Pro 6.0 and 9.0

Users of older versions of QuickBooks POS need to upgrade to the latest version in order to install and use QuickBooks on Vista in a supported environment.

While POS 5.0 and earlier versions are not Vista compatible and not supported, Intuit offers more specifics and these comments to users of POS 5.0 and earlier versions considering Vista.

If you need to upgrade, you can review detailed product comparisons as well as obtain discounts and free shipping by visiting the links on our Buy QuickBooks page.

Vote This Post DownVote This Post Up (No Ratings Yet)
Loading...

How Do I Reduce the Cash In My Cash Drawer To Deposit the Funds In My Bank Account?

Chief Mechanic · August 28, 2010 ·

To reduce the amount of cash in your cash drawer and deposit the funds in your bank account, you need to record a cash drawer payout.

If you have POS integrated with QuickBooks financial software, it’s valuable to understand how cash in a cash drawer is accounted for in QuickBooks. Cash payments from customers are recorded in the Cash in Drawer which is connected to a balance sheet bank account in QuickBooks. When you update QuickBooks financial software by clicking on the Financial->Update QuickBooks menu selection, cash transactions are recorded in the balance sheet bank account you specify in your POS company preferences. To verify this setting, click on the Advanced tab of the Financial->Accounts sub-menu on the Edit->Preferences->Company menu selection.

By default, POS sets this balance sheet bank account to Cash in Drawer, as shown in the screenshot below.

QuickBooks POS 8 Company Preferences Cash In Drawer

If you need to change this account setting, choose a valid QuickBooks bank account and save your change by clicking the Save button.

Reducing the amount of money in your cash drawer by recording a payout will:

  • reduce the balance of the balance sheet bank account recorded for that preference by entering a credit to that account
  • enter an equal, offsetting debit to an account you specify when you record the payout

To prepare to deposit funds from a cash drawer into your bank account, you’ll normally choose to debit your Undeposited Funds account, provided you are have the Use Undeposited Funds as a default deposit to account preference turned on in QuickBooks. If you don’t have that preference turned on (which we do not recommend), you’ll choose to debit the bank account into which you’ll deposit the funds from the cash drawer. See our related article for more information on the purpose of the Undeposited Funds account.

For the remainder of this discussion, we’ll assume that the Use Undeposited Funds as a default deposit to account preference is turned on in QuickBooks, and that you’re using the default balance sheet account, Cash in Drawer.

To record the payout, click on the Point of Sale->New Payout menu selection. Enter the Cashier, the Amount (which is the amount you are removing from the cash drawer to deposit into your bank account), and Comments. Choose Undeposited Funds from the Account list and click Ok.

QuickBooks POS 8 Cash Payout Undeposited Funds

When you next update QuickBooks financial software from POS, your balance sheet account Cash in Drawer will have been reduced by a debit in the amount you recorded as a payout, and Undeposited Funds will be increased by a debit in that same amount.

Click on the Banking->Make Deposits menu selection to actually include this cash on a regular bank deposit.

Vote This Post DownVote This Post Up (No Ratings Yet)
Loading...

What’s the Purpose of the X-Out and Z-Out Reports?

Chief Mechanic · August 28, 2010 ·

The terms X-Out and Z-Out originated in the world of cash registers. Registers commonly had a key-operated lock with several positions: one for normal operation, one labeled “X”, and another labeled “Z.” After inserting a key (normally in a manager’s possession) and turning it to the “X” position, the register would print a running total of the activity for that register from the point it was last reset to zero, or zeroed out. The “Z” position would “zero out” the register totals at the end of a shift or business day.

QuickBooks POS uses this same terminology for 3 similar X/Z-Out reports:

  • the X-Out Status Report (accessed on the Reports->Cash Drawer->General – X-Out Status Report menu selection)
  • the Z-Out Drawer Count Report (accessed on the Reports->Cash Drawer->General – Z-Out Drawer Count Report menu selection)
  • the Z-Out Store Close Report (accessed on the Reports->Cash Drawer->General – Z-Out Store Close Report menu selection)
    • The X-Out Status Report is designed to provide an update on sales activity to that point in the day since the register was last closed by running the End of Day Procedure (on the Point of Sale->End of Day Procedure menu selection).

      The Z-Out Drawer Count Report is intended to reconcile the cash drawer at the end of a business day. In a multiple workstation environment, this report is normally run before running the Z-Out Store Close Report.

      Because the purpose of this report is to reconcile the cash drawer, the Z-Out Drawer Count Report can be configured to require a manual media count, or a physical count of the individual bill denominations. To set this preference, click the Sales submenu on the Edit->Preferences->Company menu selection. Check the box on the Require a manual media count for X/Z Out preference.

      POS 8 Company Preferences Require Manual Media Count

      With that preference enabled, you’ll be required to enter the physical count for each bill and coin type on the Media Count window, and QuickBooks will calculate the total cash on hand. This is a safeguard to reduce the chance of error when entering the amount of cash on hand in the register.

      QuickBooks POS 8 Media Count

      When the Count you enter matches the expected amount of currency in the register, you’re in balance – with neither a shortage (less money on hand than expected) or an overage (more money on hand than expected). You can now click Ok to display and print the Z-Out Drawer Count Report.

      QuickBooks POS 8 Media Totals

      The Z-Out Store Close Report, as its name indicates, is run when closing the store at the end of the day. This report is designed for installations with multiple workstations. After all workstations have reconciled the cash drawer by running the Z-Out Drawer Count Report, the Z-Out Store Close Report will report on all sales activity from all workstations and all cashiers for the period since the End of Day Procedure was last run (on the Point of Sale->End of Day Procedure menu selection). This report is not designed to assist in reconciling the cash drawer, so it doesn’t include the ability to do a media count on the cash drawer.

      Here are samples of all 3 reports: the X-Out Status Report, the Z-Out Drawer Count Report, and the Z-Out Store Close Report.

      You can select any of these 3 reports as part of the End of Day Procedure, and you can print them on either 8 1/2″ x 11″ paper or 40 column receipt paper. This preference is managed on the Documents & Printers submenu on the Edit->Preferences->Workstation menu selection.

      Vote This Post DownVote This Post Up (+1 rating, 1 votes)
      Loading...
  • « Go to Previous Page
  • Page 1
  • Page 2
  • Page 3
  • Page 4
  • Go to Next Page »

Accounting

  • Financial Accounting Standards Board

Developer

  • Intuit Developer Network Forums
  • qbXML Onscreen Reference

Intuit

  • Enterprise Solutions
  • Intuit
  • Intuit Marketplace
  • QuickBooks
  • QuickBooks Online Community

QBGarage.com

Copyright © 2008–2025 QBGarage.com · Privacy · Terms & Conditions · Site Help