Sage 100 Accounts Payable Reports

Sage 100 Accounts Payable Reports are a useful tool included in your Sage 100 software. Here, we explain the names and purpose of each A/P report in Sage 100.

1099 Vendors

• 1099 eFiling and Reporting
• Form 1099 Printing
• 1099 Reports
  • Payment History Report by Vendor Number
  • Select the 1099 information box on the AP Trial Balance before closing each month
  • Distribute to GL acct

Vendor Reports

• Vendor Listing
  • The Vendor Listing report to produce a list of vendors and related information, such as constant data, balance data, memos, and 1099 payment history.
• Vendor Listing with Balances
  • The Vendor Listing with Balances report is similar to the Vendor Listing report. The report lists vendor information and the period-to-date, year-to-date, and prior year totals on the Summary tab in Vendor Maintenance.
• Vendor Mailing Labels
  • The Vendor Mailing Labels report prints vendor names and addresses on perforated labels. Options available include:
    • Form codes to align and format labels to fit your needs
    • Multiple label printing for each vendor
• Vendor Memo Printing
  • The Vendor Memo Printing report prints information entered on any existing memos for one or more vendors.
    • Select the Print Memo Detail check box to include the actual memo text.
    • If this check box is cleared, only the memo ID, description, date, expiration date, reminder start date, reminder stop date, and auto display setting appears on the report.
• Vendor Audit Report
  • The Vendor Audit Report provides information on changes, deletions, or additions to vendor information. This report is only available if you selected to track changes in Accounts Payable Options.

AP Transaction Reports

• Vendor Inquiry
  • Use Vendor Inquiry on the Main menu to quickly review or display information for a specific vendor without the ability to make changes.
  • Uses the same tabs and information accessible in Vendor Maintenance.
• Invoice History Inquiry
  • Use Invoice History Inquiry on the Main menu to view detailed or summary invoice information including invoice header and general ledger distribution detail.
  • Invoice History Inquiry is also accessible by selecting an invoice on the Invoices tab in Vendor Maintenance or Vendor Inquiry.
    • This task is available only if the Track Detailed Invoice/Payment History check box is selected in Accounts Payable Options.
• Payment History Inquiry
  • Use Payment History Inquiry on the Main menu to view information for all checks entered in the system.
  • Payment History Inquiry is also accessible by selecting a check on the Checks tab in Vendor Maintenance or Vendor Inquiry.
    • This task is available only if the Track Detailed Invoice/Payment History check box is selected in Accounts Payable Options.
• Accounts Payable Check History Report
  • The Accounts Payable Check History Report on the Reports menu provides a recap of all checks printed for a specified period. You can also view all manual or voided checks for the same specified period.
• Accounts Payable Trial Balance Report
  • The Accounts Payable Trial Balance Report on the Reports menu provides a complete recap of Accounts Payable balances as of the last day of the month. This is the suggested report for reconciling to General Ledger. The detail on this report includes:
    • Invoices, payments, and adjustments
    • Other activities which affect Accounts Payable balances
    • This report is based on the posting date and it is the suggested report for reconciling to General Ledger
• Accounts Payable Invoice History Report
  • The Accounts Payable Invoice History Report on the Reports menu provides a summary or detailed listing of each invoice posted.
  • This report is available only if you selected Yes or Summary at the Retain in Detail field in Accounts Payable Options.
  • Line item detail information is also provided for each invoice if you selected Yes at the Retain in Detail field in Accounts Payable Options.
• Payment History Report
  • The Payment History Report on the Reports menu provides a detailed listing of each check including the check number, check date, vendor number, vendor name, invoice number, invoice amount, and check amount.
  • You can sort the report by check number, vendor number, or vendor name.
  • You have the option of including all or a range of vendors, checks, and check dates.
• General Ledger Posting Recap
  • The General Ledger Posting Recap report on the Reports menu provides a detailed recap, by general ledger account, of all postings made from Accounts Payable.
    • Note: The Invoice Register, Check Register, Manual Check Register, and Daily Transaction Register are used to track transactions you have not updated.
• AP Expense by GL Account Report
  • The AP Expense by GL Account Report on the Reports menu produces a report displaying each invoice posted by general ledger account number.
  • Information on the report includes: vendor number, vendor name, invoice number, invoice date, invoice status, source journal, transaction date, and distribution amount, and last check number.
    • The report can include only paid invoices, open invoices, or all invoices.
    • You can choose to print the report for a range of account numbers, vendors, transaction dates, departments, and locations.
• Open Invoice by Job Report
  • The Open Invoice by Job Report on the Reports menu provides you a detailed listing, sorted by job number, of all open invoices distributed to a job. Each job cost distribution is printed in detail and sorted by job number, cost code, and cost type.
    • Only available if Job Cost is activated.
• Accounts Payable Sales Tax Report
  • The Accounts Payable Sales Tax Report on the Reports menu provides you with a recap of sales tax information.
  • You can print this report in a summary or detailed format and includes taxable purchases, nontaxable purchases, taxable freight, nontaxable freight, taxable tax,exempt purchases, recoverable/nonrecoverable amount, and sales tax/use tax amount for each tax code.
  • The accumulated sales tax collected prints for each tax code and primary tax code.
    • Note: This report is available only if the Sales Tax Reporting check box is selected in Accounts Payable Options.

Management Reports

• Monthly Purchase Report
  • The Monthly Purchase Report provides you with a recap of PTD purchasing activities entered in Accounts Payable. You should print this report before closing the period.
• Vendor Purchase History by Period
  • The Vendor Purchase History by Period report provides vendor purchase history information by period for a specified fiscal year.
  • A total for each division prints along with a report total except when sorting by total purchases or total payments.
  • Information for each division prints on a separate page if the Accounts Payable Divisions check box is selected in Accounts Payable Options.
• Vendor Purchase Analysis
  • The Vendor Purchase Analysis report provides a recap of total purchases, payments, discounts taken, and discounts lost.
  • You can select which fiscal year and period to include on the report.
  • You can also determine if period-to-date, year-to-date. and prior year totals are provided for the period and year selected.
• Accounts Payable Analysis
  • The Accounts Payable Analysis report provides a graphical representation of Accounts Payable. The report provides:
    • A statistical summary of payables activity
    • An aging recap for up to six consecutive periods
• Accounts Payable Analysis Report
  • The Accounts Payable Analysis Report provides you with an in-depth management report consisting of an aging recap and statistical summary of payables activity for up to six consecutive periods.

For more information regarding Sage 100 Accounts Payable Reports, call Accounting Business Solutions by JCS today at 800-475-1047 or email us at solutions@jcscomputer.com. Our certified Sage 100 consultants offer Sage 100 training classes, including how to use Sage 100 Accounts Payable reports.