Managing Receivable Accounts

Accounts receivable are accounts that you establish with your customers to manage future payments for current sales.

 

Watch the following video as a supplement to reading this article:

 

Receivable Setup

Receivable Association

Receivable Management

Receivable Statements

Receivable Reports

 

In the sections below, we explain how to perform these tasks:

 

 

Accessing Accounts Receivable

To access this feature, click the Accounting button in the Home ribbon and then click on Receivable the tab at the bottom of the left window pane, as shown in the figure.

 


Searching for an Existing Receivable Account

Follow these steps to search for a receivable account:

 

  1. Access the Accounts Receivable feature, as we explain above.

  2. Click in the Search field at the top of the left window pane, enter the search term and then press the Enter key (or click the Search button in the ribbon).

  3. Select the receivable account from the resulting list in the left window pane.

  4. The detail of the receivable account will appear in the right window pane.

Add, Edit, or Delete a Receivable Account

Access the Accounts Receivable feature, as we explain in the first section. Then follow the steps below for editing, adding, or deleting a receivable account.

Edit an existing receivable account

  1. Search for and select a specific receivable account, as we explain in the section above.

  2. Click the Edit command button in the ribbon to display a popup containing the details of the account.

 

Add a new receivable account with a contact

This procedure is identical to what is given in the Setup > Accounting > Receivable Accounts article in this guide. Follow these steps to create a new receivable with a contact:

 

  1. Click the Add button in the ribbon to open the Receivable Account popup.

  2. If you only want to create a basic receivable account with no contacts, check the second box and continue to the next subsection.

 

  1. To create a receivable account with a contact, check the first box and then click the Next button to move to the next panel.

  2. Enter the Contact information, and then click the Next button.

  3. Enter all of the information for the account and click the Save button.

 

Add a new receivable account without a contact

This procedure is identical to what is given in the Setup > Accounting > Receivable Accounts article in this guide. Follow these steps to create a receivable account without a contact:

 

  1. Click the Add button in the ribbon to open the Receivable Accounts popup.

  2. Check the second box to create a bare receivable account and click the Next button.

  3. Enter all of the information for the account and click the Save button.

 

Later, you can add contacts by following the instructions in the next section.

 

Associate a contact with a receivable account

You can associate one or more contacts with a receivable account, which gives you the flexibility of having multiple suppliers posting to the same receivable account. Follow these steps to associate a contact with a receivable account:

 

  1. Access the Accounts Receivable feature, then search for and select a specific receivable account (instructions can be found in the sections at the top of this article).

  2. In the Receivable Account popup, click the Associated Contacts tab (see the figure below), which lists any contacts which already have an association with the account.

  3. To associate another contact, click the Add button.

  4. In the Contacts window, add a new contact–or search for an existing contact.

  5. After choosing a contact, click the Save button in the Receivable Account popup.

 

 

Delete a Receivable Account

Follow these steps to associate a contact with a receivable account:

 

  1. Access the Accounts Receivable feature, then search for and select a specific receivable account (instructions can be found in the sections at the top of this article).

  2. Click the Delete command button located in the ribbon.

  3. Type "yes" into the field and click OK to confirm the deletion.

 
The receivable account will no longer appear in the listing.
 

Sorting Transactions for a Receivable Account

To sort the transactions listing for a receivable account, simply click on the header of any column to sort by that column .

 

 

Click a second time to reverse the sort order. (See the figure below.)

 

NOTE: The running balance amount may become erroneous if the sort is on a column other than the Date column.

 

Print, Export, or Email Receivable Account Detail

To perform any of these actions, begin by accessing the Accounts Receivable feature, then search for and select a specific receivable account (instructions can be found in the sections at the top of this article).

 

Print Preview

Follow these additional steps to preview the printout of the receivable account details:

 

  1. Click the Print Preview button in the ribbon.

  2. The Windows Print Preview popup will appear, on which you can choose from multiple options for previewing the document.

  3. Click the x to close the preview window.

Printing Account Details

Follow these additional steps to print a hardcopy of the receivable account details:

 

  1. Click the Print command button located in the General group of the ribbon.

  2. The Windows Print popup will appear, on which you can choose from multiple options and print the document.

  3. Click OK to print the document.

Export Account Detail to a PDF file

Follow these additional steps to print a hardcopy of the receivable account details:

 

  1. Click the Export to PDF button in the ribbon to open the Export to PDF popup.

  2. Navigate to the location in your file system in which to save the PDF document.

  3. Edit or enter the filename.

  4. Click the Save button to create the PDF file and close the popup.

 

Email Details of the Receivable Account

Follow these steps to send an email of the details for a receivable account:

 

  1. Click the Email button in the ribbon to open the Email popup.

  2. Review the TO email address to ensure it is correct, or enter another email address for the primary recipient. See the figure below.

  3. If necessary, add email addresses in the CC and BCC fields.

  4. Edit the Subject, if necessary.

  5. Optionally, edit the body of the email message and click Send button in the ribbon.

 

Print and Email an Account Statement for an Individual Account

Follow these steps to print and/or email the details for an individual receivable account:

 

  1. Access the Accounts Receivable feature, then search for and select a specific receivable account (instructions can be found in the sections at the top of this article).

  2. Click the Statement button in the ribbon to open the Statement popup. See the figure below.

  3. Using the dropdown, choose a Start Date and End Date elect the applicable date range

  4. Check the boxes to either Print and/or Email the statement. Select the applicable check box to print or email.

  5. Click the Next button.

  6. Choose a Printer and Tray, if necessary.

  7. If you chose to print, the Windows Print popup window will appear, in which you can set your printing options. Click OK to print the statement.

  8. If you chose to email, the Email popup opens, in which you can edit the email much like we explain in the previous section.

 

 

 

Print and Email an Account Statement for multiple accounts

Follow these steps to print and/or email the details for multiple receivable accounts simultaneously:

 

  1. Access the Accounts Receivable feature then select the Utilities tab.

  2. Click the Prepare Statement button in the ribbon to open the Statement popup.

  3. Using the drop-down, choose a Start Date and End Date to choose the applicable date range.

  4. Check the boxes of the customers for which you would like to print a statement and to Print and/or Email the statement.

  5. Click the Next button.

  6. Choose a Printer and Tray, if necessary.

  7. If you chose to print, the Windows Print popup window will appear, in which you can set your printing options. Click OK to print and email the statements.

Finding Specific Transactions in the Receivable Account Detail

Follow these steps to locate specific transaction(s) for a receivable account:

 

  1. Access the Accounts Receivable feature, then search for and select a specific receivable account (instructions can be found in the sections at the top of this article).

  2. Click on a receivable account listing on the left.

  3. If the transaction list on the right is extensive, click the Find button located in the ribbon to display the Find popup window.

  4. Make selections in the Find and Compare drop-downs, and enter all or part of the search term in the Value field.

  5. Click the Find All to display a listing of all matching transactions, or click the Find Next button to iterate through each transaction.

 

View a Customer Invoice, Credit Invoice, or Bank Transaction

Follow these steps to locate a specific invoice for a receivable account:

 

  1. Access the Accounts Receivable feature, then search for and select a specific receivable account (instructions can be found in the sections at the top of this article).

  2. Looking in the Description column for the document type, select a Customer Invoice or Credit Invoice from the list of transactions in the right window pane and click the corresponding button in the ribbon.

  3. If neither a credit invoice is shown , then click on the Associated Document button in the ribbon to display the document.

 

Viewing / Adjusting a Receivable Transaction

Follow these steps to adjust a specific transaction for a receivable account:

 

  1. Access the Accounts Receivable feature, then search for and select a specific receivable account (instructions can be found in the sections at the top of this article).

  2. Select Customer Invoice or Adjustment from the list of transactions in the right window pane.

  3. Click on the Transaction button in the ribbon to display the Transaction Details popup, which will contain the original transaction and any other related  transactions.

 

Adjust a transaction

Follow these steps to make an adjustment to a transaction:

 

  1. Click on the Action drop-down and choose Adjustment from the list to open the adjustment popup window.

  2. Choose a Date.

 

  1. The general ledger will auto-generate an Entry Number, but you may enter in your own if necessary.

  2. From the Adjustment Account drop-down list, select the account on which you want to post your adjustment against.

  3. Describe the adjustment in the Description field.

  4. The Amount Outstanding value is the amount outstanding when taking into account the original transaction and all other related transactions.

  5. Enter the amount of your Adjustment. A positive amount will generate a debit on the receivable account (adding to the transaction) and a negative amount will credit the receivable account (subtracting from the transaction).

  6. The Total displays the total for the adjustment.

  7. The Amount outstanding after adjustment is the amount of the outstanding when taking into account the original transaction and all other related transactions–including the current adjustment.

 

NOTE: Taxes will be calculated automatically on the adjustment amount if the taxes are chosen in the adjustment settings (Setup > Other Charges > Adjustment). If there is no check in that box, taxes are not calculated automatically.

 

  1. If you need to adjust taxes or other charges, click the Tax Adjustment button.

  2. Check the box adjacent to any tax or other charge you wish to adjust.

  3. Overstrike the amount in the text box provided.

  4. Click the OK button to save your changes.

 

 

Make a Payment

Follow these steps to make a payment on a receivable account:

 

  1. Access the Accounts Receivable feature, then search for and select a specific receivable account (instructions can be found in the sections at the top of this article).

  2. Click the Make a Payment button in the ribbon to open the Make a Payment popup window, as shown in the figure.

 

 

  1. Choose the payment Date.

  2. Enter a Payment Amount, though you can edit the value in this field, typically this value will automatically update as you choose transactions (see the instructions further below).

  3. From the drop-down, choose the customer Payment Method.

  4. Enter a Description for payment, which will appear throughout the entire accounting system.

  5. Select the transactions you wish to pay by checking the box in the S column. The Payment Amount value will reflect the total of all the transactions that have a check in box for this column.

  6. Click the OK button to commit your payment entries.

 

NOTE: The payment function does not display credits on the account. It is recommended that payments are made using the Reconcile button. See the section below to learn how to apply a credit.

 

Applying a Credit

Follow these steps to apply a credit to a receivable account:

 

  1. Access the Accounts Receivable feature, then search for and select a specific receivable account (instructions can be found in the sections at the top of this article).

  2. From the listing, select the transaction to which you want to apply a credit.

  3. Click the Apply Credit button in the ribbon to open the Apply Credit popup window, as shown in the figure.

 

 

  1. Select an Applying Date, which is the date of record for this credit.

  2. The Credit Date displays the date of the credit you are applying.

  3. Enter a Credit Amount.

  4. The Selected Amount is the total value of transactions chosen in the Transaction List (as we explain in the next step).

  5. Select the transactions for which you want to apply a credit by checking the box in the S column. The Select Amount value will reflect the total of all the transactions that have a check in box for this column.

  6. Click the OK button to commit your changes and apply the credit.

 

Delete a Receivable Transaction

NOTE:  You can only delete transactions that are not system-generated. That is, you may only delete entries that a user has entered directly into the receivable account.

 

Follow these steps to delete a receivable account transaction:

 

  1. Access the Accounts Receivable feature, then search for and select a specific receivable account (instructions can be found in the sections at the top of this article).

  2. Select the transaction from the listing.

  3. Click on the Delete button in the ribbon.

  4. Type "yes" into the field and click OK to confirm the deletion.

 

Purge One or More Receivable Accounts

Follow these steps to purge a single receivable account:

 

  1. Access the Accounts Receivable feature, then search for and select a specific receivable account (instructions can be found in the sections at the top of this article).

  2. Click the Purge button in the ribbon to display the receivable Purge popup window.

  3. Select a Purge Date – all transactions with zero outstanding amounts and having a post date earlier (and also including) this date will be hidden from the receivable account popup.

  4. Click the Continue button

 

The transactions are now purged. To undo the purge, click the Undo Last Purge command button.

 

To Purge all receivable accounts

Follow these steps to purge all receivable accounts:

 

  1. Click the Utilities tab at the top of the Shop Manager window. See the figure below.

  2. Click the Batch Purge button in the ribbon to display the receivable Purge popup window.

  3. Choose a Purge Date  – all transactions with zero outstanding amounts and having a post date earlier (and also including) this date will be hidden from the receivable account popup.

  4. Click the Continue button.

 

All transactions for this account are now purged. To undo the purge, click the Undo Last Purge command button.

 

 

 

Reconcile the Receivable Account

Follow these steps to reconcile a receivable account:

 

  1. Access the Accounts Receivable feature, then search for and select a specific receivable account (instructions can be found in the sections at the top of this article).

  2. Click on the Reconcile button located in the ribbon. The Reconcile Receivable Account popup window opens.

  3. Choose the Payment Date.

  4. Select the transactions you want to be part of this reconciliation by checking the box in the S column. The Selected value will reflect the total of all the transactions that have a check in box for this column.

  5. Use the Find button to locate transactions on the reconciliation popup window (much like the instructions found for finding specific transactions).

  6. The Match function gives you the ability to specify an ending date for included transactions.

  7. Click the Action button to see options for quickly selecting and de-selecting all transactions.

  8. Click the Next button to bring these transactions to the next step.

  9. Check the Automatically Purge box to immediately perform a purge following the completion of the payment transaction.

  10. Select a Payment Date, enter a Payment Amount, and choose a Payment Method.

  11. Click the OK button to perform the reconciliation according to your specifications.

 

Add a Service Charge to an Individual Account

Follow these steps to add a service charge to a receivable account:

 

  1. Access the Accounts Receivable feature, then search for and select a specific receivable account (instructions can be found in the sections at the top of this article).

  2. Click on the Service Charge button in the ribbon to open the Service Charge popup window.

  3. Select a Service Charge Date, which is the date  on which all overdue items will be charged.

  4. If desired, add a value for a Grace Period that extends beyond the specified payment terms of the receivable account.

  5. The value of the Total Overdue is an amount based on the due date plus the grace period.

  6. Automatic or By Amount - Select one of the two calculation methods. Automatic calculated service charge is based on a specific % rate; Amount is a fixed dollar value.

  7. Service Charge displays the amount of charge to be applied to the customer account.

  8. Select OK.

 

A transaction for the service charge will be added to the receivable account.

 

Add a Service Charge to multiple accounts simultaneously

NOTE:   In order for this feature to calculate service charge, rates must be set on individual receivable accounts. To add a service charge to an existing receivable account, follow the steps in the previous section.

 

Follow these steps to add a service charge to a receivable account:

 

  1. Access the Accounts Receivable feature, then select the Utilities tab.

  2. Click on the Apply Service Charges button in the ribbon to open the Service Charge popup window.

  3. Select a Service Charge Date, which is the date  on which all overdue items will be charged.

  4. As you require, check or uncheck the box Skip customers with current service charges.

  5. Select Start.

  6. A transaction for the service charge will be added to all applicable receivable accounts that have overdue balances as of the Service Charge Date.