Accounts Receivable


Chapter Topics
Introduction
Clients Catalog
AR Catalogs
AR Transactions
AR Documents
AR Processes
AR at the Point of Sale
Receiving AR Payments at the POS
AR Reports

Introduction
XpertMart™’s Accounts Receivable (AR) module gives you all of the tools you need to manage your sales on credit with your customers. To begin with, the module can be used as a stand-alone program to manage credit accounts without ever interacting with the Point of Sale. In addition, the AR module can also be used as a fully integrated part of XpertMart’s Point of Sale.

XpertMart™’s AR module resides on the Main in the Multi-Store Edition and can be included in the Single-Store Edition. In a multi-store setup the Remote Stations only interact with the AR module through the Point of Sale.

Clients Catalog
The AR module uses the same Client Catalog to store all of the data of credit account customers. There are a few fields and one toolbar button used especially for AR:

The first field is Credit Limit. At the Main Station this field is editable and used to put the customer’s maximum credit limit. The second field is Balance, which is not an editable field. The AR Module will automatically update this field with the amount owed by the client. The third filed is Days Credit. This field can be edited at the Main station and is used to enter the maximum number of days the customer has to pay for the purchases bought on credit. In transactions made at the Point of Sale the Due Date will automatically appear as the Days Credit added to the current date of the transaction. The Days Behind field displays the days that have passed since the balance was due.

The Client Catalog also includes a special button to open the AR Audit Log. The button looks like the yellow Kardex button with a green dollar sign on it as shown below:



When you click on this button a new window will open with the AR Audit Log for the custome you are looking at, as shown here:


 
The AR Audit Log gives a complete transaction history for a customer's credit account. It includes the date and time in which a transactions was made, the type of transaction which was made, the unique document number for the transaction followed by the starting balance prior to the transaction, the amount of the transaction and finally the ending balance after the transaction is accounted.


AR Catalogs
The data which appears in the AR Audit Log is stored in the AR Audit Catalog. This catalog can be oepend by going to Catalogs>Accounts Receivable>AR Audit Catalog as shown below:



When you select this option, the AR Audit Catalog will open up, as shown below:



As can be seen in this image, this catalog has the same data found in AR Audit Log. Perhaps the main reason for using the AR Audit Catalog is to run the reports associated with this catalog.

The names given to the different Accounts Receivable transactions may vary from company to company. Therefore, the user can name these transactions as desired in the AR Transaction Types Catalog. This catalog can be opened by going to Catalogs>Accounts Receivable>AR Transaction Types, as shown below:



Once you select this option the AR Transaction Types Catalog will open. The catalog includes a field where you can assign a name as well as an internal ID number that is not editable.



XpertMart™ uses Transaction Type ID = 1 as a charge or something that was sold on credit and for which payment is still due. You can give this Transaction Type whatever name you wish but XpertMart™ will assume it is a charge. Transaction Type ID = 2 is used as a payment against a balance that is due. Transaction Type ID =3 is used a debit memo. These are used for charges that do not arise from normal sales. For example, debit memos can be used for surcharges if a check is returned, for a late fee or special interest charge. The last Transaction Type is ID = 4 and is used for credit memos which are used to credit an account and reduce the amount owed outside of taking in a payment. For example, if you offer a discount for quick payment, you would want to use Transaction Type ID = 4. As mentioned before, you can use whichever names you'd like for these transaction typeswithout affecting the underlying functionality just described. At present, only four transaction types are used.

A central feature of the Accounts Receivable module is clasifying debts by due date and the time that has lapsed since then.
XpertMart™ allows you to define the lenght of time periods you wish to use to track overdue payments. Normally the periods used are: 0 - 30 days, 30 - 59 DAYS, 60 - 89 dayns and over 90 days. To define these periods, use the AR Periods Catalog. To open this catalog, go to Catalogs>Accounts Receivable>AR Periods, as shown below:



Once you select this option, the AR Periods Catalog will open, as shown below:



Use the first field for the name you want to use for the period. You can use whichever name you like. Then select how many days past due mark the beginning of hte period and how many days past due mark the end of the period. As can be seen in the image above, you must have an initial period that starts with zero days past due. This initial period is for accounts that ar considered current. You can use the number of days you'd like, but the important thing is not to skip any days. For example, if one period ends with 30 days then the next period must begin with 31 days. Also, you must enter the periods you want to use in order such that Period ID = 1 is used for current accounts, Period ID = 2 is used for accounts that are more than one day past due, and so on. The AR Aging Report will used these periods to display overdue accounts.

The last entry in the AR Periods Catalog is for all delincuent accounts over "x" days past due. For example, if the final period runs to 120 days, then you must add another entry in the catalog which begins with 121 days past due and runs to 9,999 days past due. This period could be called "More than 120 Days" for example.


AR Transactions
All four transaction types in the AR module can be processed manually. To make any one of these transaction types, go to Transactions>Accounts Receivable, as shown below:



The first type of AR Transaction is a Charge which gets recorded as a balance that needs to be paid at a future date. To make a Charge transaction, go to Transactions>Accounts Receivable>Accounts Receivable Charge, as shown below:



Once you select this option, a new transaction screen will open up, as shown below:



There are a number of fields in which to enter data. The Document # field refers to the number of the document which generated the Charge such as the number of the invoice which was sold on credit. The Document Date refers to the date of the document which generated the charge. This date may be different than the date of the Charge itself. The Employee field is non-editable and is filled in automatically with the Employee Number of whoever is logged in at the time. The No. field is the unique document number for this charge transaction. This number is generated automatically by the system and runs sequentially starting with 10,000,000.

On the second line of the transaction screen is the Amount field which is where you enter the amount that is being charged. The Due Date field is where you enter the date on which the amount being charged is due for payment. The Store field displays the store number where the charge is being made and is filled-in automatically by the system and is not editable. If you are making the charge at the Main then this field is left blank. The Date field displays the date of when the charge is being made (today's date) and is not editable.

On the third line, the AR Type field displays the name for the transaction type you entered into the AR Transaction Types Catalog with an ID = 1. This field is not editable. The Description field is an open field where you can enter a description for the charge being processed.

The Client field works the same way it does in an Invoicing screen. You can do a Lookup by Example by Last Name to enter the client for which the Charge is being processed.

The next section details the AR transactions and documents which are used to pay this charge. The Total Debit, Total Credit and Balance fields reflect the totals of all transactions listed in this section. The Balance field displays the total amount of the charge minus any credits and debits which have been applied. This transaction details section is explained below.

Lastly, the Notes field allows you to enter an explanation for the charge being process or include special instructions.

If after entering all of the relevent information pertaining to a charge in the fields described above you wish to appy any open credits or positive balances, you can do so simply by pressing the Payment
<F10> button.

When you press
<F10> the system will first check to see if the charge transaction has all the required information. The system will first check to see that you've entered a Client. If you have not specified a client you will see this error message:
 


If the client has not been specified you need to do so before proceeding. Next, the system will check to make sure the amount entered is greater than zero. If no amount has been entered in the Amount field, you will see this error message:



If you have not entered an amount fo the Charge you will need to do so before proceeding. Next, the system will prompt you with this window asking if you 'd like to apply any open credits automatically or manually:



At this point you need to decide if you'd like to apply any open credits yourself of let the system do it. If you are not ready to decide, press
<Cancel>.

Whenever XpertMart™ automatically applies open credits it will always apply these to the oldest document first and, if there's still a positive balance left, will then apply it to the second oldest document and so on in order. If the balance of the open credit is less than the total amount due on a document then XpertMart™ will apply the full credit and leave the remaining balance as pending to be paid.

If on the other hand you elect to apply open credits manually then you can decide the amounts you wish to apply to the documents of your choosing.

Below is a sample of how
XpertMart™  applied an open credit automatically:

   

The first thing to notice ist aht
XpertMart™  will add a line which registers the current transaction being processed. In the image above, the first line refers to AR Transaction number 10000014 and the amount being charged is $300.

The second line shows that
XpertMart™  found document number 20000001 which has an open credit of $17.50 which has not yet been applied to any prior document so XpertMart™ is applying it now. That's why it shows up under the Credit column.

The image below, on the other hand, shows what happens if you tell
XpertMart™ you want to apply the credits manually:



In this case
XpertMart™  also finds the open credit of $17.50 from document 200000001 which this client has in their favor. Since this credit has not been used before, XpertMart™ places it in the Available Credit column so that the user knows it's available. If you wish to use this credit then you have to manually enter the amount ($17.50) in the Credit column. Or you can choose to only use a portion of this credit and enter it in the Credit column.

To save and print these changes you need to click
<F12>. Note that if before you press <F12> you change the amounts or enter a different client then XpertMart™ will not save any of the transaction detail. You must press <F12> for your transaction detail to be saved.

Just as when you press
<F10> to commit a Charge, XpertMart™ will check to see that you've specified a client and have entered an aount before printing. XpertMart™ will also check to see that you've specified a Document Number and will display an error notice if you have not.

If all of the infromation is complete (client, amount and document number) then
XpertMart™ proceeds with the transaction. If after applying open credits the Charge still has an active balance then XpertMart™ will ask you if you'd like it to apply any open credits to the document. These would be any open credits you had previously not applied. If you'd like XpertMart™ to apply these automatically, then click <Apply>. If you'd like to leave the balance as pending to be paid, then click <Don't Apply>. If you decide you don't wish to save and print the transaction then you can click <Cancel> and the transaction screen will clear out.

The second type of AR transaction you can make is a Payment. To do this, go to Transactions>Accounts Receivable>Accounts Receivable Payment. This will open a new transaction window, as shown below:



As can be seen above, the fields that need to be filled out are the same as when making a Charge transaction. The only difference is that the amount will be credited to the customer's balance instead of debited. All AR Payment documents begin with document number 20,000,000. When looking at the AR Audit Log you can tell just by looking at the document number which transactions are Payments (start with 2) and which are Charges (start with 1).

The
<F10> Payment button works the same way only instead of applying credits you will be applying debits. This is because you will be choosing which open balances to apply this payment against.

The
<F12> button works the same as before and is used to save and print the transaction. None of the payments are applied until you actually press <F12>.

The third AR transaction type you can make are Debit Memos. These are used to register a charge to a client's account for something that is not a merchandise sale. To make one, go to Transactions>Accounts Receivable>Accounts Receivable Debit Memo, as shown below:
 


Once you select this option, a new transaction window will open, as shown below:



As seen with Charges and Payments, the fields to fill out are the same and the <F12> and <F12> keys work the same way. In fact, a Debit Memo works exactly like a Charge does, the only difference being the document number which starts with 30,000,000.

The final AR transaction type are Credit Memos. These are used to reduce the total balance due for any reason other than a payment. To make one, go to Transactions>Accounts Receivable>Accounts Receivable Credit Memo, as shown below:



Once you select this option, a new transaction window will open, as shown below:



As seen with Charges and Payments, the fields to fill out are the same and the <F12> and <F12> keys work the same way. In fact, a Crebit Memo works exactly like a Payment does, the only difference being the document number which starts with 40,000,000.

The printing format for each of the four AR transaction types can be set by going to Configure>Configure Documents>AR Transaction Format.



Select the report format you want to use for each transaction type. The default formats are shown above.


AR Documents
All AR Transactions get stored as Documents. These documents can be found under Documents>AR Transactions, as shown below:



Once you select this option, a Catalog of previous AR Transactions opens up, as shown below:



All four AR Transaction Types are found here. You can use all of
XpertMart™'s usual Catalog and Search functions to find the data you're looking for.

The AR Documents screen has two addiitional fileds that the AR Transaction screen does not have. The Past Due Days field displays how many days past due is the balance. The number of days past due is based on the last time you ran the process to calculate days past due. The Past Due field displays the AR Period the balance falls under.

The AR Transactions catalog also includes a Payment button you can use to apply payments to open charges (or vice-versa). The Payment button has a dollar sign on it and looks like this:



When you press the button,
XpertMart™ will check to see if the balance on the transaction you are looking at is zero. If the balance is zero then it is no longer necessary to apply any payments, in which case you'll see this notice:



After displaying this message
XpertMart™ will not do anything further since the transaction does not have any open balances. If on the other hand there is an open balance then XpertMart™ will check to see if the client in question has any open credits or any payments that have not yet been applied. If the client does not have any open credits or payments waiting to be applied, you will see this notice:



After displaying this message
XpertMart™ will not do anything further since the transaction does not have any open balances.

If the balance is greater than zero and the client does in fact have open credits then
XpertMart™ will proceed to ask you if you'd like the open credits applied automatically or manually, the same way it does in an AR Transaction screen when you press <F10>. You will see this dialogue window:



The functionality here is the same as described earlier when using the <F10> Payment button in a Transaction screen. The only difference is that instead of pressing <F12> to save the changes and print, in the Documents screen you will press the Payment button on the toolbar a second time to commit the changes.



When you press the Payment button a second time the system will ask you to confirm that you want to commit these changes to the Document you are looking at.



Press
<Yes> to commit these changes to the Document. If you press <No> the credits will not be applied.

Note that the example above dealt with applying open credits to Charges and Debit Memos but the procedure is exactly the same for apply open debits to Payments and Credit Memos.

AR Processes
There are two processes you should run regularly to keep your Accounts Receivable up to date. These two processes are found under Processes>Accounts Recevable Processes, as shown below:



As previously mentioned,
XpertMart™ can automatically apply open credits by taking any open credit and applying it to the oldest open debit or charge document and working its way formard. If you'd like XpertMart™ to do this for every single client where there is an open credit then you can select Processes>Accounts Receivable Processes>Apply open credits, as shown below:



Once you select this option, a dialogue window will appear notifying you that
XpertMart™ is applying the open credits.



When the dialogue window closes it means the system is done applying open credits.

The second process consists of calculating how many days past due every balance is and under which AR Period the charge falls under. To do this, go to Proceses>Accounts Receivable Processes>Calculate days past due, as shown below:



When you select this option a dialogue window will appear notifying you that the system is calculating the days past due. When the dialogue window closes it means the system is done calculating days past due. Note that the number of days past due is based on the last date you ran the Calculate days past due process so it is important to run this processes before running any AR Reports.

The last option in the Accounts Receivable Processes menu is to run both processes at the same time.




When you select this option 
XpertMart™ will first apply all open credits and will then calculate days past due. This way if after applying an open credit a charge now has a balance of zero it will show zero days past due and the account will be considered current.

This concludes the overview of Accounts Receivable as a stand-alone module in
XpertMart™. We will now see how AR integrates into the Point of Sale.


AR at the Point of Sale
Once you've setup the three AR Catalogs then you are ready to begin selling on credit at the point of sale. You need to setup one configuration setting at the Main in order for credit sales at the POS to be automatically applied to a client's account through the AR module. To set this up, go to Configure>Accounts Receivable Configure, as shown below:



When you select this option the Configure Accounts Receivable window opens up, as seen below:



The first configuration option on the left-side menu is Accounts Receivable Posting. If you check the box that says "Automatically apply charges and payments from POS" then the system will automatically update each client's records in the AR Module. If you don't check this option then all charges and payments made at the POS are left open for you to apply later at the Main using the AR Module. If you're going to be applying charges and payments automatically at the Main anyway, you might as well go ahead and select this configuration option now.

The second configuration option is called Credit Balances.




If you select the "Increase credit balance when purchases are paid via credit" box then each client's available credit will adjust dynamically as payments are made and open credits are applied.

To sell on credit at the point of sale all you need to do is select "Credit" as the Tender Type, as shown below:



Note that Credit must be Payment Type ID = 7 when you setup the Payment Types Catalog. Refer to the Required Entries topic for further informaiton.

When you select Credit as the tender type
XpertMart™ will first check to see if you've entered a Client in the Invoice. If you have left the Client field blank, XpertMart™ will not let you use Credit as a tender type.

Next,
XpertMart™ will check that the Client you've selected has available credit greater than the amount being charged in the Invoice. Available credit is calculated as the Credit Limit you entered in the Client Catalog minus any open charges and debits that have not yet been paid.

If you are using
XpertMart™'s Single Store Edition then any sale made on credit will automatically be applied at that moment to the AR Modlule. If you are using the Multi-Store Edition then all sales made using the Credit tender type will be applied to the AR Module after a synchronization cycle.

XpertMart™ will record the Invoice number as the Document number in the AR Transaction. In the Notes field of the AR Transaction, XpertMart™ will insert the Invoice's reference field. The AR Module will record a Due Date equal to the date of the Invoice plus the Days Credit you've previously assigned in the Client Catalog.


Receiving AR Payments at the POS
You can also receive payments towards a clients AR balance at the point of sale. To be able to do this you first have to create new entries in two catalogs. First, create an Invoice Type with ID = 12 called "Credit Account Payment" in the Invoice Types Catalog which is found under Catalogs>Document Types>Invoice Types.



Next, create a Credit/Charge type with ID = 10 called "Credit Account Payment" in the Credits Charges Catalog which is found under Catalogs>POS>Credits/Charges.



When you're in an Invoicing screen if you pick Invoice Type ID=12 (Credit Account Payment) then
XpertMart™ will automatically fill in Credit/Charge Type ID = 10 int he Cr/Ch Type drop-down menu. In the Creidt/Charge field, enter the amount the client is paying. Obviously you also need to enter a ame in the Client field and you must specify the Tender Type being used to make the payment. In the example below, the Client is making a $100 payment towards his AR balance and is paying cash.



XpertMart™ will check to see that all required data has been entered. If you have not specified a Client, you will see this error notice:



You must specify a Client in order to continue. Likewise,
XpertMart™ will check to see that you are using Credit/Charge Type ID = 10. If you are not, you will also see an error notice and you will have to change the entry in the Cr/Ch Type drop-down menu to Credit Account Payment.

As with selling on credit at te point of sale, if you are using
XpertMart™'s Single Store Edition then any payments made at the point of sale will instantly be applied to the AR Module. If you are using XpertMart™'s Multi Store Edition then they will be applied after a full synchornization cycle.

XpertMart™ will record the Invoice number as the Document number in the AR Transaction. In the Notes field of the AR Transaction, XpertMart™ will insert the Invoice's reference field.


AR Reports
The AR Module includes several reports you can use to manage your client's credit accounts. These are found by going to Documents>AR Transactions and clicking on the Reports button. Most of these reports are also found in the Clients Catalog.



The "Account Statement Balance Based with Running Balance" report will produce Balance Statements for each client showing all activity and the resulting balance for a given date range. The "Accounts Receivable Aging Vertical" report will show all the overdue balances
grouped by AR Transaction Period.


Copyright © 2008  Tech Soft, Inc.

* Return to Table of Contents *