ARDISSCN Accounts Receivable A/R Distribution to G/L Report

A/R Distribution to G/L Report

Application Overview

 

Whenever Sales, Cash Receipts, or Finance Charge transactions are posted to the A/R files, postings are also made to the A/R Distribution to G/L file.  These are records of the postings to be made to the various General Ledger accounts.

 

If you are using Elliott’s General Ledger package, you can transfer these Accounts Receivable postings to General Ledger on demand for use in preparing your company's Financial Statements.

 

Sections of the Report

 

There are five sections to the A/R Distribution to G/L Report, the Income section, the Cash Receipts section, the Net Change to A/R section, the Cost of Goods Sold section and the Inventory Section.  Whenever a transaction is posted in the Accounts Receivable package, another second transaction is also posted to keep General Ledger in balance. For example, every time a sales transaction is posted which increases an income account, a second transaction will also be posted which increases either a cash account (if the purchase was paid for in cash), or an A/R account (if the transaction went onto a customer's account for later collection).  When a payment is received, typically these two transactions would be generated; one transaction recording the increase to the Cash Account, and one transaction recording the decrease in A/R. When an inventory item is sold (using Customer Order Processing), typically these two transactions would be generated; one transaction recording the increase to the Cost of Goods Sold Account, and one transaction recording the decrease in Inventory Asset Account.  The A/R Distribution to G/L Report prints these five types of trans­actions in separate sections for easier reference.  The Income section of the report will contain postings, which came from these sources:

 

                        Sales Distributions

                        Freight Charges

                        Miscellaneous Charges

                        Sales Tax

                        Finance Charges

 

The Cash Receipts section contains postings which came from these sources:

 

                        Cash

                        Discounts

                        Allowances

                        Non‑A/R Cash Accounts Credited

 

The A/R Net Change section of the report shows every change to the total amount of the company's A/R.

 

Detail or Summary Formats

 

You can print the A/R Distribution to G/L Report in either a detailed or a summary format.  If you print the report in detailed format, all distributions which have occurred during the period you select will be printed, with detail concerning the source of the transaction, such a the customer number, document number and type of transaction which generated the posting.

 

If you select the summary format, on the other hand all postings to G/L for the same date for an account will be summarized and printed on one line of the report.

 

Purging the File

 

Once you have printed the A/R Distribution to G/L Report and you are satisfied that it is accurate, you can then purge the A/R Distribution file of the transactions, which appeared on the report.  Purging the file periodically will prevent it from growing extremely large.

 

If you are using Elliott’s General Ledger package, however, and if you plan to transfer these A/R postings to G/L, do not purge the A/R Distribution file.  If you do, you will not be able to transfer the postings to G/L.

 

Run Instructions

 

Select A/R Distribution to G/L Report from the pull down A/R Reports window.   The following screen will then be displayed:

 

 


 

A/R Distribution to G/L Report Entry Screen

 

 

 The following options are available:

  • Print to screen, the general ledger distributions for a given date range in detail or summary
  • Purge the distribution file only after interfacing to G/L

 

To return to the menu bar, press the ESC or F10 key.  To leave this application, press X for EXIT when positioned at the menu bar.


Entry Field Descriptions

 

Name

Type and Description

1.  Print Report ?

Y or N. 

If you answer Y then the report will be generated, otherwise it will not.  Default is Y.

2.  Purge File ?

Y or N.

Do not purge if you wish to interface with the General Ledger package.  Default is N.

3.  Period Starting Date

A date in the standard date format.

Enter the beginning date of the period for which you want to print the report.  Default to system date.

If you press RETURN for this entry, it will default to All, and all distributions on file will be printed.

4.  Period Ending Date

A date in the standard date format.

Enter the ending date of the period for which you want to print the report.

Default to system date.

If you press RETURN for this date, it will default to the starting date entry.  In other words, only distributions dated with the starting date will appear on the report.

5.  Starting Account

An account in the standard account number format.

Enter the starting account in the range you want to include in your report, or press RETURN to default to All accounts.

6.  Ending Account

An account in the standard account number format.

Enter the ending account in the range you want to include in your report, or press RETURNto default to the same account as you previously entered in the starting account field.

If RETURN was entered in the starting account, this field will be skipped.

7.  Starting Customer No

6 alphanumeric characters.

Enter the starting customer number, in the range that you want to plot.

If you press RETURN for the entry of the starting customer, the field will default to Allcustomers, and the ending customer will be skipped.

8.  Ending Customer No

6 alphanumeric characters.

Enter the ending customer number, in the range that you want to plot.

9.  Detail Or Summary ?

1 alphanumeric character.

Enter D if you want the report to show the full detail of every transaction, which generated a posting to G/L.  If you answer S, every transaction which occurred on a single date for an account will be summarized and will print on one line.

Default to D.

 

 

 


 

A/R Distribution To G/L Report (Detail)

 

 

 

 

 


 

A/R Distribution To G/L Report (Summary)

 

 

 

Accounts Receivable

  1. ARMENU Accounts Receivable Package Overview
  2. Feature - Elliott AR ACH Processing
  3. How to Automatically Credit Check an Order After Filling Back Order
  4. Fine-Tuning Customer File Maintenance Security
  5. I Receive "No Open Item on File" Message When I Try to Reapply Open Credit or Payment in AR
  6. Can I Reapply a Payment to a Different Customer in AR?
  7. AR Aging Report - What's the Difference Between Py and Px Payment Type ?
  8. Avg Days Pay YTD in Customer File Calculation Issue
  9. Opn Ord Pick/Inv Amt Calculation Issue
  10. Auto Assigned Sales Tax Code by State and County
  11. How to Handle Sales Tax for Single Item with Caps Amount
  12. How to Subscribe a Customer Event by Salesman?
  13. Arizona Cities Not in Elliott for Sales Tax Code Auto Assign
  14. AR0111 Accounts Receivable Carrier File Maintenance
  15. AR0112 Accounts Receivable Carrier Mode Maintenance
  16. AR0113 Accounts Receivable Freight Rate File Maintenance
  17. AR0114 Accounts Receivable Freight Zone File Maintenance
  18. AR0120 Accounts Receivable State Table File Maintenance
  19. ARACTINQ Accounts Receivable Customer Account Inquiry
  20. ARACTMNT Accounts Receivable Account File Maintenance
  21. ARACTSUM Accounts Receivable Customer Account Summary Inquiry
  22. ARADJAUD Accounts Receivable Adjustment Auditing Inquiry
  23. ARADJSCN Accounts Receivable Adjustment Auditing Report
  24. ARAGEBAL Accounts Receivable Age Customer Accounts
  25. ARAGEMNU Accounts Receivable Aging Reports
  26. ARAPLYCR Accounts Receivable Re-Apply CR/DR Memos
  27. ARCALFCH Accounts Receivable Finance Charges Processing
  28. ARCNTMNT Accounts Receivable County Tax Code File Maintenance
  29. ARCRCMNT Accounts Receivable Credit Card Transacting Handling
  30. ARCRDSCN Accounts Receivable Credit Card Log Report
  31. ARCSHENT Accounts Receivable Cash Receipts Processing
  32. ARCSHSCN Accounts Receivable Cash Projection Report
  33. ARCTLMNT Accounts Receivable A/R Setup
  34. ARDBEXPS Accounts Receivable Export D&B Customer File
  35. ARDISSCN Accounts Receivable A/R Distribution to G/L Report
  36. ARECIMNT Accounts Receivable Customers and Contacts Import Utility
  37. ARHSTMNU Accounts Receivable A/R History Report
  38. ARINVSCN Accounts Receivable Print Service Invoices
  39. ARJBASCN Accounts Receivable Job Analysis Report
  40. ARJOBMNT Accounts Receivable Job Code File Maintenance
  41. I Can Only Enter A/R Cash Receipt for Cash or Check
  42. ARCUSMNT Accounts Receivable Customer File Maintenance
  43. ARLTRMNT Accounts Receivable Customer Mail Merge
  44. Feature - ACH Deposit Effective Date
  45. AROLOAD Accounts Receivable A/R Open Item File Maintenance
  46. ARPRDEND Accounts Receivable Clear A/R Accumulators
  47. ARPRGSCN Accounts Receivable Purge Closed Open Items
  48. ARRECENT Accounts Receivable Recurring Sales Processing
  49. ARSAMENU Accounts Receivable Sales Analysis Report
  50. ARSETBAL Accounts Receivable Set Customer Account Balances
  51. ARSHPMNT Accounts Receivable Ship Via Code File Maintenance
  52. ARSLMMNT Accounts Receivable Salesman File Maintenance
  53. ARSLSENT Accounts Receivable Sales and CR/DR Memo Processing
  54. ARSRCMNT Accounts Receivable Payment Source File
  55. ARSRVENT Accounts Receivable Service Invoice Processing
  56. ARSRVMNT Accounts Receivable Service File Maintenance
  57. ARSTMSCN Accounts Receivable Print Statements
  58. ARTAXMNT Accounts Receivable Tax Code File Maintenance
  59. ARTRMMNT Accounts Receivable Terms Code File Maintenance
  60. ARTYPMNT Accounts Receivable Customer Type File Maintenance
  61. ARSTLSCN Accounts Receivable Sales Tax Liability Report
  62. Incorrect Opn Ord Pick/Inv Amount in Customer File
  63. Feature - Customer Account Inquiry Reference Search
  64. Feature - Tax Freight Setup User Messages in COP Setup and Tax Code Maintenance
  65. ARFRMMNT Accounts Receivable Invoice Form Setup
  66. Feature - Customer Highest Balance YTD, Last Year, and Year Before Last Year
  67. Feature - Ship Via Group Support
  68. Feature - Scheduling ACH Payments
  69. How to Print A/R Aging Report by Salesman
  70. Feature - A/R Expanded Aging Report - Add "Show Open Items Only" Option
  71. Feature - Add Acct Name to ACH Account Detail Screen
  72. Feature - ACH Add and Change Event
  73. Feature - Import A/R Cash Receipt Detail -- Add Ability to Process Multiple Customers for One Check
  74. Feature - A/R Commissions Due Reports - Additional Fields and CSV Support
  75. Feature - Age Customer Accounts When Cash Receipts Are Posted
  76. Feature - Validate Collector Against Salesman File
  77. NSCTLMN2 Accounts Receivable Global Setup 1
  78. NSCTLMN2 Accounts Receivable Global Setup 2
  79. NSCTLMN2 Accounts Receivable Global Setup 3
  80. NSCTLMN2 Accounts Payable Global Setup 1
  81. NSCTLMN2 Accounts Payable Global Setup 2
  82. NSCTLMN2 Accounts Payable Global Setup 3
  83. NSCTLMN2 Accounts Payable Global Setup 4
  84. NSCTLMN2 Accounts Payable Global Setup 5
  85. NSCTLMN2 Accounts Payable Global Setup 6
  86. NSCTLMN2 Accounting Global Setup: Index
  87. Accounts Receivable Cash Receipts Reports That Show Check Deposits for a Period of Time
  88. What Does the Asterisk Mean in A/R Account Inquiry?
  89. ARRECMNT Accounts Receivable Customer/eContact Import Utility
  90. Refund Customer for Open Credit or Over Payment
  91. Feature - Defer Cash Receipts with Wildcard Batch Entry
  92. Feature - Exclude Debit Memos from Updating Customer Sales Ptd/Ytd

Feedback and Knowledge Base