# AR Month End

<p class="callout info">a checklist is provided with this documentation to assist you in the successful completion of the accounts receivable month end. </p>

### <a name="_Toc87870070"></a><a name="_Toc87847656"></a><a name="_Toc87847580"></a><a name="_Toc87846357"></a><a name="_Toc87846281"></a><a name="_Toc87845848"></a><a name="_Toc87783925"></a>Set Statement Date

**1. ACCOUNTS RECEIVABLE &gt; 5. MONTH END PROCESSING &gt; 1. SET STATEMENT DATE**

The date should be the last date on which **Invoices** or other **Transactions** were processed, normally the last date of the month. The **Accounts Receivable &gt; ar Month End** routines are run after the last business day of the month, and after the **Sales desk control &gt; Sales desk month End** routines have completed. The **AR Month End** must be completed before the next **End of Day** process is run, and is designed to be run from start to finish at one time.

### <a name="_Toc87870071"></a><a name="_Toc87847657"></a><a name="_Toc87847581"></a><a name="_Toc87846358"></a><a name="_Toc87846282"></a><a name="_Toc87845849"></a><a name="_Toc87783926"></a>Service Charge Processing

#### <a name="_Toc87870072"></a><a name="_Toc87847658"></a><a name="_Toc87847582"></a><a name="_Toc87846359"></a><a name="_Toc87846283"></a><a name="_Toc87845850"></a><a name="_Toc87783927"></a>Calculate Service Charges

**1. ACCOUNTS RECEIVABLE &gt;5. MONTH END PROCESSING &gt;2. SERVICE CHARGES &gt;1. CALCULATE SERVICE CHARGES**

This program will calculate the Service Charges based on the figures that you have previously set up in **9. SYSTEM UTILITIES &gt;3. SYSTEM SETUP &gt; 1. ACCOUNTS RECEIVABLE &gt; 1. SYSTEM Parameters** , you may wish to double check the ensure that they are correct before you run this procedure for the first time.

Only those customers flagged \[**y**\] in the **1. accounts receivable &gt; 1. data maintenance &gt; 1. customer** field number **55. Service charges** will be considered for calculation.

Once the **service charge calculation** has taken place, do **NOT** use this option again, until and unless you have deleted **all** the system calculated service charges using the **service charge adjustments** process. If you do so, then customer records will be updated with duplicate service charges.

#### <a name="_Toc87870073"></a><a name="_Toc87847659"></a><a name="_Toc87847583"></a><a name="_Toc87846360"></a><a name="_Toc87846284"></a><a name="_Toc87845851"></a><a name="_Toc87783928"></a>Service Charge Edit List

**1. ACCOUNTS RECEIVABLE &gt; 5. MONTH END PROCESSING &gt;2. SERVICE CHARGES &gt;2. SERVICE CHARGE EDIT LIST**

This process will create and print a **Transaction Edit List** of all transactions entered/created for verification before updating and will also print a **GL summary Edit List**, which totals the proposed entries to the General Ledger during **Update**.

#### <a name="_Toc87870074"></a><a name="_Toc87847660"></a><a name="_Toc87847584"></a><a name="_Toc87846361"></a><a name="_Toc87846285"></a><a name="_Toc87845852"></a><a name="_Toc87783929"></a>Service Charge Adjustments

**1. ACCOUNTS RECEIVABLE &gt;5. MONTH END PROCESSING &gt;2. SERVICE CHARGES &gt;3. SERVICE CHARGE ADJUSTMENTS**

Any changes you wish to make to the calculated entries shown on the **Transaction Edit List** have to be done as a **Change or Delete** (to remove the service charge completely). The Add option will allow you create a Service Charge to a Customer’s account when none has been calculated and follows the same format as those processed in **accounts receivable &gt; transaction processing**. Make sure that type \[**1**\] is chosen.

#### <a name="_Toc87870075"></a><a name="_Toc87847661"></a><a name="_Toc87847585"></a><a name="_Toc87846362"></a><a name="_Toc87846286"></a><a name="_Toc87845853"></a><a name="_Toc87783930"></a>Service Charge Update

**1. ACCOUNTS RECEIVABLE &gt;5. MONTH END PROCESSING &gt;2. SERVICE CHARGES &gt;4. SERVICE CHARGE UPDATE**

Press \[**ENTER**\] to continue if you are ready to update the **Service Charge Transactions**, then \[**ENTER**\] to start the Update. The screen will display the date and time as it completes each step. A **Transaction Journal** and a **GL Journal** will print automatically. Once the update completes, the service charge entries will appear on the customer account and can be displayed in **accounts receivable &gt; customer analysis** screen.

### <a name="_Toc87870076"></a><a name="_Toc87847662"></a><a name="_Toc87847586"></a><a name="_Toc87846363"></a><a name="_Toc87846287"></a><a name="_Toc87845854"></a><a name="_Toc87783931"></a>Trial Balance Reports

#### <a name="_Toc87870077"></a><a name="_Toc87847663"></a><a name="_Toc87847587"></a><a name="_Toc87846364"></a><a name="_Toc87846288"></a><a name="_Toc87845855"></a><a name="_Toc87783932"></a>Detailed Trial Balance

**1. ACCOUNTS RECEIVABLE &gt; 5. MONTH END PROCESSING &gt;3. TRIAL BALANCE REPORTS &gt;1. DETAILED TRIAL BALANCE**

This report will print the **Customer number** and **name**, the **document type** and **number, date**, **reference** and the **amount** for any and all entries made to the customer during the period, or since the last **open item purge** completed. Each customer account is totalled, but there is no ageing on this report.

#### <a name="_Toc87870078"></a><a name="_Toc87847664"></a><a name="_Toc87847588"></a><a name="_Toc87846365"></a><a name="_Toc87846289"></a><a name="_Toc87845856"></a><a name="_Toc87783933"></a>Open Item Purge

**1. ACCOUNTS RECEIVABLE &gt; 5. MONTH END PROCESSING &gt; 3. TRIAL BALANCE REPORTS &gt; 2. OPEN ITEM PURGE**

This program will purge all **fully paid items** from the customer’s account. A fully paid invoice is one that has either a **payment** or **Credit Memo** applied against it, or a combination of the two in or to bring the net amount of the invoice or document to $0.00.

#### <a name="_Toc87870079"></a><a name="_Toc87847665"></a><a name="_Toc87847589"></a><a name="_Toc87846366"></a><a name="_Toc87846290"></a><a name="_Toc87845857"></a><a name="_Toc87783934"></a>Aged Detail Trial Balance

**1. ACCOUNTS RECEIVABLE &gt; 5. MONTH END PROCESSING &gt; 3. TRIAL BALANCE REPORTS &gt;3. AGED DETAIL**

The Detailed Aged Trial Balance report will age the amounts owing on the customer’s transactions based upon the criteria set up in the **9. SYSTEM UTILITIES &gt; 3. SYSTEM SETUP &gt; 1. ACCOUNTS RECEIVABLE &gt; 1. SYSTEM ParameterS** file. You may wish to check this to ensure it is correct prior to running these reports for the first time.

This report shows the **customer number** and **name**, the **document number, date** and **reference**, and the **net amount** owed on the account. Then the documents are aged as current, 30 days, 60 days, 90+ days and any future amount (if you used the **cash receipts processing &gt; Dating Terms** function). The net amount and the aged amounts are totalled.

#### <a name="_Toc87870080"></a><a name="_Toc87847666"></a><a name="_Toc87847590"></a><a name="_Toc87846367"></a><a name="_Toc87846291"></a><a name="_Toc87845858"></a><a name="_Toc87783935"></a>Aged Summary Trial Balance

**1. ACCOUNTS RECEIVABLE &gt; 5. MONTH END PROCESSING &gt; 3. TRIAL BALANCE REPORTS &gt; 4. AGED SUMMARY**

The Summary Aged Trial Balance report will age the amounts owing on the customer’s transactions based upon the criteria set up in the **9. SYSTEM UTILITIES &gt; 3. SYSTEM SETUP &gt; 1. ACCOUNTS RECEIVABLE &gt; 1. SYSTEM ParameterS** file. You may wish to check the fields called **summary aged totals** prior to running this report for the first time.

This report shows the **customer number, name** and **phone number**, the **documents/invoices** are aged at current, 30 days, 60 days, 90+ days and any future amount (if you used the Dating Terms function) and the totals are printed.

#### <a name="_Toc87870081"></a><a name="_Toc87847667"></a><a name="_Toc87847591"></a><a name="_Toc87846368"></a><a name="_Toc87846292"></a><a name="_Toc87845859"></a><a name="_Toc87783936"></a>Aged Detail Trial Balance – Alpha

**1. ACCOUNTS RECEIVABLE &gt; 5. MONTH END PROCESSING &gt; 3. TRIAL BALANCE REPORTS &gt; 5. AGED DETAIL - ALPHA**

This is the same report as the **Aged Detailed Trial Balance**, but it prints in **Customer Name** order instead.

#### <a name="_Toc87870082"></a><a name="_Toc87847668"></a><a name="_Toc87847592"></a><a name="_Toc87846369"></a><a name="_Toc87846293"></a><a name="_Toc87845860"></a><a name="_Toc87783937"></a>Aged Summary Trial Balance – Alpha

**1. ACCOUNTS RECEIVABLE &gt; 5. MONTH END PROCESSING &gt; 3. TRIAL BALANCE REPORTS &gt; 6. AGED SUMMARY - ALPHA**

This is the same report as the **Aged Summary Trial Balance**, but it prints in **Customer Name** order instead.

#### <a name="_Toc87870083"></a><a name="_Toc87847669"></a><a name="_Toc87847593"></a><a name="_Toc87846370"></a><a name="_Toc87846294"></a><a name="_Toc87845861"></a><a name="_Toc87783938"></a>Aged Detail by Salesman

**1. ACCOUNTS RECEIVABLE &gt; 5. MONTH END PROCESSING &gt; 3. TRIAL BALANCE REPORTS &gt; 7. AGED DETAIL BY SALESMAN**

This is the same report as the **Aged Summary Trial Balance** with the customers by SALESMAN

#### Aged Summary Trial Balance by Salesman

**1. ACCOUNTS RECEIVABLE &gt; 5. MONTH END PROCESSING &gt; 3. TRIAL BALANCE REPORTS &gt; 8. AGED SUMMARY BY SALESMAN**

This is the same report as the **Aged Summary Trial Balance** with the customers grouped by **Salesman**. After each salesman’s customers are printed, a total is printed for each of the ageing periods.

<p class="callout danger">Here you would process your statements. Review the Statements documentation and resume from here.</p>

### <a name="_Toc87870093"></a><a name="_Toc87847679"></a><a name="_Toc87847603"></a><a name="_Toc87846380"></a><a name="_Toc87846304"></a><a name="_Toc87845871"></a><a name="_Toc87783948"></a>Balance Forward Update

1. ACCOUNTS RECEIVABLE &gt;5. MONTH END PROCESSING &gt;5. COMPLETE MONTH END &gt;1. BALANCE FORWARD UPDATE

If you have balance forward customers, then use this option to take all the current invoices for each customer and combine them into one **balance forward** total. Once this step has completed, all details that have been displayed on the **Customer Analysis** screen will be removed and replaced with the **balance forward** figure.

### <a name="_Toc87870094"></a><a name="_Toc87847680"></a><a name="_Toc87847604"></a><a name="_Toc87846381"></a><a name="_Toc87846305"></a><a name="_Toc87845872"></a><a name="_Toc87783949"></a>Balance Forward Aging

**1. ACCOUNTS RECEIVABLE &gt;5. MONTH END PROCESSING &gt;5. COMPLETE MONTH END &gt;2.. BALANCE FORWARD AGING**

Once the details have been combined to one value, the ageing process must take place, advancing each balance into the correct age, current, 30 days, 60 days and 90+ days.

### <a name="_Toc87870095"></a><a name="_Toc87847681"></a><a name="_Toc87847605"></a><a name="_Toc87846382"></a><a name="_Toc87846306"></a><a name="_Toc87845873"></a><a name="_Toc87783950"></a>AR Month End Update

1. ACCOUNTS RECEIVABLE &gt;5. MONTH END PROCESSING &gt;5. COMPLETE MONTH END &gt;3. a/r month end update

Once all steps are complete, the **ar month end Update** can commence. This option will advance the **GL period** for **Accounts Receivable**. If you want to confirm that the update has completed successfully, then check the **accounts receivable &gt; data file maintenance &gt; AR Parameters File** for the value in the **Financial Period** field.

### SET STATEMENT DATE

**1. ACCOUNTS RECEIVABLE &gt; 5. MONTH END PROCESSING &gt;5. COMPLETE MONTH END &gt; 4. SET STATEMENT DATE**

Set the statement date to the next month end for proper aging on the invoice screen.

### <a name="_Toc87870097"></a><a name="_Toc87847683"></a><a name="_Toc87847607"></a><a name="_Toc87846384"></a><a name="_Toc87846308"></a><a name="_Toc87845875"></a><a name="_Toc87783952"></a>Customer Counter Balances Reset

**1. ACCOUNTS RECEIVABLE &gt; 5. MONTH END PROCESSING &gt;5. COMPLETE MONTH END &gt; 5. COUNTER BALANCES RESET**

Use this option to recalculate the customer’s ageing figures that appear at the bottom of the screen during **sales desk &gt; Invoicing/transfers**. The statement date should be reset to the end of the new month prior to resetting the customer balances. Otherwise, any sales made in the new month will be considered as **future**.