AP0900 Accounts Payable AP Distribution to GL Report

A/P Distribution to G/L Report

Application Overview

 

The A/P Distribution to G/L Report is a list of all transactions from A/P that affect the General Ledger. The report can be printed in detail, showing each entry with its vendor number and voucher number, or it can be printed in summary, showing only one entry per date per account.  The report is printed from the A/P Distribution to G/L File, which is also used for the automatic interface within General Ledger.  The report would normally be printed once every accounting period and then the file purged, but the information can be retained on file indefinitely if desired.

 

This Report is available in any combination of the following 5 Report Types:

 

       Expense Distributions

       New A/P Added

       Checks Written

       Discounts Taken

       A/P Paid

 

Once you have selected your Report Types, you have the print to report by:

 

1.   Interfaced Items

2.   Non-Interfaced Items

3.   Both Interfaced and Non-Interface

 

Expense Distributions

 

These are entries to be posted to the expense accounts.  In the case of purchases of assets, such as inventory or office furniture, this section would contain asset accounts.  Most of them will be debits, which were added to the A/P Distribution to G/L File when new A/P transactions were posted.  They are normally counterbalanced by credits to an A/P account.  For example, a voucher is entered for a shipment of $1,000 worth of computer supplies and $2,000 worth of office supplies, with a $40 freight charge.  This transaction increases expenses (a debit) and increases A/P (a credit).  Therefore, there might be a $1,000 debit to the computer supplies expense account, a $2,000 debit to the office supplies expense account, and a $40 debit to the freight expense account.  These entries would be counterbalanced by a credit entry of $3040 to an A/P account, which would be found in the New A/P Added section of this report.

 

New A/P Added

 

These are entries to be posted to the A/P accounts.  Most of them will be credits, which were added to the A/P Distribution to G/L File when new A/P transactions were posted.  They are normally counterbalanced by debits to asset or expense accounts.  See the example under Expense Distributions.

 

Checks Written

 

These are entries to be posted to the cash accounts.  Most of them will be credits, which were added to the A/P Distribution to G/L File when a check was printed.  They are normally counterbalanced by debits to an A/P account.  For example, a check for $100 is written to pay a $100 invoice, which has previously been entered into the system as an A/P open item.  This transaction decreases cash (a credit) and decreases A/P (a debit).  Therefore, there would be a $100 credit to a cash account and a $100 debit to an A/P account.

 

Discounts Taken

 

These are entries to be posted to the discount accounts.  Most of them will be credits, which were added to the A/P Distribution to G/L File when a check was written to pay an invoice with a discount.  They are normally counterbalanced by debits to an A/P account.  For example, a check for $95 is written to pay a $100 invoice with a $5 discount.  This transaction decreases cash (a credit), increases discounts taken (a credit), and decreases A/P (a debit).  Therefore, there would be a $95 credit to a cash account, a $5 credit to a discount account, and a $100 debit to an A/P account.

 

A/P Paid

 

These are entries to be posted to the A/P accounts.  Most of them will be debits to the A/P accounts, which were added to the A/P Distribution to G/L file when a check was written to pay an invoice, which has previously been entered into the system as an A/P open item.  See the examples under Checks Written Paid and Discounts Taken.

 

Run Instructions

 

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



A/P Distribution To G/L Report Entry Screen:








Accounts Payable

  1. AP0000 Accounts Payable Overview
  2. What Is The Difference Between Payment Date and Check Date during Print AP Check?
  3. How to Purge AP Distribution to GL Report
  4. DYO (Design Your Own) AP Laser Check Design
  5. How Can I Get a List of New Vendors Set Up Since a Certain Date?
  6. Why Doesn't the System Print the Bottom Stub on My Design-Your-Own AP Laser Check?
  7. System Period Control Does Not Apply to Recurring Transactions
  8. AP Check History Report That Includes Voided Check
  9. ERROR 035 on AP TEMP CHK File
  10. Feature - Voucher Criteria On Vendor Account Summary
  11. Feature - Voucher Reference on A/P Distribution to G/L Report
  12. Feature - A/P Simple Trx Processing
  13. AP01S4 Accounts Payable Vendor Audit Trail Report
  14. AP05S1 Accounts Payable A/P Open Item Report
  15. AP07S1 Accounts Payable Cash Requirements Report
  16. AP08S1 Accounts Payable Pre-Check Writing Report
  17. AP08S2 Accounts Payable Post A/P Checks
  18. AP08S4 Accounts Payable Void Checks After Posting
  19. AP10S1 Accounts Payable Check Reconciliation Report
  20. AP11S1 Accounts Payable Check History Report
  21. AP13S1 Accounts Payable Vendor History Report
  22. AP22S1 Accounts Payable Purge AP Open Item File
  23. AP0200 Accounts Payable Post AP Transactions
  24. AP0301 Accounts Payable Recurring Voucher Processing
  25. AP0302 Accounts Payable Post Recurring AP Transactions
  26. AP0400M Accounts Payable Vendor Account Inquiry
  27. AP0601 Accounts Payable Open Item Adjustment
  28. AP0800 Accounts Payable Payment Preparation
  29. AP0900 Accounts Payable AP Distribution to GL Report
  30. AP1001 Accounts Payable Check Reconciliation
  31. AP1200 Accounts Payable Vendor Analysis Report
  32. AP1400 Accounts Payable Job Distribution Report
  33. AP1500 Accounts Payable Job Analysis Report
  34. AP1600 Accounts Payable A/P Setup
  35. AP1701 Accounts Payable A/P Account File Maintenance
  36. AP1801 Accounts Payable FOB Code File Maintenance
  37. AP1901 Accounts Payable Ship Via Code File Maintenance
  38. AP2001 Accounts Payable Job Code File Maintenance
  39. AP2100 Accounts Payable Print/Create 1099 Forms
  40. AP2300 Accounts Payable Clear Vendor YTD Accumulators
  41. APDISSCN Accounts Payable Distribution History Report
  42. APINVIMS Accounts Payable Invoice Import Utility
  43. AP0100 Accounts Payable Vendor File Maintenance
  44. AP0202 Accounts Payable Transaction Processing
  45. FULLPAY Accounts Payable Reset Fully Paid Status
  46. Feature - Default Value For Create Variance Prompt
  47. Feature - Assign Next Manual Check Number in Computer Check Printing
  48. Feature - Added First Bank Export Format to Checks History Export
  49. I Forgot to Clear the AP Vendor Paid Accumulators at Year End
  50. What If I Do Not Run AP Manual Check Register?
  51. Feature - Add Ability to Include or Exclude by Vendor Type for AP Checks
  52. How to Find a Voided AP Check in Check History Report
  53. What Are the Impacts of Purging Accounts Payable Old Inactive Vendors?
  54. Feature - AP Check History CSV Creation
  55. AP Laser Check Layout
  56. How to Apply AP Credit to Voucher When Credit Is Greater Than Voucher Amount
  57. Feature - Add Amigo Support to Additional Transactional Files

Feedback and Knowledge Base