Zeroing out credit and balances

Zeroing out credit and balances

There may be cases where your clients have credits or balances on their accounts.  This can be because they make deposits for future bookings, paid extra on an invoice and asked to keep the change on their account as a credit, decided to pay you next time, and so on.  There may be times when you need to zero out their account.  


Zeroing out credits


To get a list of clients with credits on their accounts, click on Reports, Revenue, Credit Balance.  We'll use Fred Bailey as an example. He has three deposits on his account, totalling $130.


Lite users


Lite users don't have access to inventory so they are unable to setup an inventory item for this procedure.  You can contact Sales if you'd like to upgrade to the Standard version to use an inventory item.  Sales@SoftwareConnectionLLC.com or 1-888-486-4343 option 1. 


You can use an item that you don't normally use.  We'll use Mileage in this example.


Create an invoice for Fred.


Choose Mileage and change the description to Zeroing out credit, for example.


Put $130 in the Each column.  



Zeroing out account



Click Take Payment/Pay.


Click the Pay box for the invoice you created and the Pay box for the three deposits.  


Hit OK to save the receipt.  The credits have now been cleared from this account.



Zeroing out account



On your Sales report, you will see the item listed with the description for reference.


Standard Users


You can create an inventory item just for this situation and can separate it out on your sales report.


Click on File, Inventory.


Click on the Categories bubble.


Hit New, enter Zeroing out account, for example, then click Save.


Zeroing out account



Next, click on the Inventory bubble.


Hit New.


Enter Zeroing out account in the code and description fields.


Choose the Category you just created.


Hit Save when done.



Zeroing out account



Now you are ready to create the invoice for Fred.


Choose the new inventory item you just created.


Enter $130 in the Each column.



Zeroing out account



Hit Take Payment/Pay.


Check the Pay box for the invoice and the Pay box for the three deposits.  The credits have now been cleared from this account.



Zeroing out account



This will be in its own category on your Sales report.



Zeroing out account



Zeroing out balances


To get a list of clients with balances on their accounts click on Reports, Revenue, Open Invoices.  We'll use Lilith Abington as an example.



Zeroing out account



To clear out balances, you can either add a line item to the invoice as a negative amount or you can create a payment method for this situation.


If you use the QuickBooks DirectLink, QB does not allow for invoices with negative line items so you will need to use the payment method option.


Payment Method


To enter a payment method, click on File, Lists, Payment Methods.


Hit New Pay Method.  The field is small so you can call it Clear Account, for example.  Hit Save when done.


You can open the invoice through Accounting, Receipts, or through the client card.


Take Payment/Pay.  


Check the Pay box for the invoice and choose Clear Account as the payment method. 


When you hit OK, this balance will be cleared from the account.



Zeroing out account



This payment will be separated out on the receipts report.



Zeroing out account



Inventory item


Since Lite users don't have access to inventory, you will need to use an existing inventory item.  We'll use Mileage.


Open the invoice and on the next blank line, add Mileage and change the Each column to -$134, the amount of the invoice.


When you hit OK to save the invoice, the balance has now been cleared from this account.



Zeroing out account



Standard users can create an inventory item for this situation.  We'll use the same Zeroing out account created previously.



Zeroing out account



The negative amount will show on the sales report.  Remember the sales report looks at the date of the invoice so if this invoice is from a past date, you'll need to run the Sales report for the right date(s).



Zeroing out account



    • Related Articles

    • Live Access - Using deposits/credits

      You are able to add credits to the client's account or add a deposit to the appointment screen and use that to pay an invoice. To add a credit, go to the client card and click on Financials. Click on Add a Credit. Enter the amount and hit Pay. Choose ...
    • Live Access - Payment options: Split payments, partial payments, using credits

      Split Payments You are able to split payments on an invoice, paying part with cash and part with a credit card, for example. Here is a $391.10 invoice that the client wants to pay $100 in cash and $291.10 on a credit card. Click Save Invoice and Pay. ...
    • Warning if no credit card on file

      You can enable a warning message if a client does not have a credit card on file. Click on File, System Options, Global tab. Check the box for 'Warn if no credit card is listed for bookings'. There will be a warning message on the appointment screen.
    • Installing a Credit Card Patch for Tenerum

      Welcome to Kennel Connection's Integrated Credit Card Processing! If you're viewing this article, odds are you've received your hardware and you're ready to get started! The first step will be to download and install the CC data into your KC software ...
    • Credit Card Processing Troubleshooting Guide (Tenerum)

      If you are unable to process credit cards and you're using Tenerum, please complete the steps in this guide to attempt to resolve the issue.  Section 1: Error: Cannot find API Tenerum.net Section 2: Error: 9999 Validation error upon request Section ...