You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
You are viewing the article in preview mode. It is not live at the moment.
Payables Overview
print icon

Payable invoices and detail can be accessed two different ways. Access to Accounts Payable can be from the Accounting System menu under B. Accounts Payable, or use the [F8] option under the Vendor File view.

This is a basic overview of A/P use this to understand A/P prior to setup or importing balances.  Refer to Accounts Payable  for details on this area, refer to 5a.1 Beginning Vendor Balances  section to enter Beginning A/R Balances, refer to Quickbooks Import/Export if importing Beginning Balances from Excell or Quickbooks. 

Column Headings

 

Vendor Vendor ID as setup in the Vendor Maintenance file 
Invno Invoice Number, payable invoice number from vendor 
Inv-Date Invoice Date, date the invoice was issued from the vendor 
Amt Amount of the payable invoice 
Other Information Return amount and Description, or the PO# as sent from PO’s 
Pay Pay Status (O=open, N=not selected for payment, P=to be paid) 
Open Open Status (Paid=Y, default is blank for Un-Paid)
Due-Date Due Date on the Payable invoice as agreed with the Vendor 
Discount Discount amount allowed as setup in Vendor Maintenance 
Balance Total balance of the invoice due, minus the discount if any exists

Function Keys

Function keys shown at the bottom of the screen:

[ESC] press [Escape] to exit the Sales Ledger view
[F2] New press [F2] to create a New Record
[F4] Edit press [F4] to edit the selected record
   [F5] Delete press [F5] to delete the selected record
[Pay] press P or select [Pay] to mark an invoice to be Paid
   [F6] Options; contains payment, searching, reporting options
[F7] Print menu options
[F8] Process Batch payment procedure
[F9] Toggle view option between Paid Invoices and Open Invoices
[F10] Search press [F10] to search for a vendor by name, vendor must be on file
[F3] Find press [F3] or select [Find] to search by any Detail: invoice date, charge, discount, PO#, due date, ect…

 

Manually Adding Payable Invoices

Press [F10] to locate Vendor Account
Press [F2] to add a new payables invoice manually.
The cursor will begin in the Invoice Number field; fill in the Invoice Number as provided by the vendor, the system will not accept duplicate invoice numbers.
Enter the invoice number
Enter the invoice amount
Double check the due date, discount date and discount amount
If the expense vendor is setup with general ledger numbers verify the distributions
Use the [F10] feature to search for a General ledger number to apply this invoice
When the correct GL numbers and distribuitons are entered and the transaction (debits = credits) balance, save the transaction
there are four different ways to save the transaction
Ctrl+Enter
[F4] Close
Click with the mouse on the <<OKAY>> button

*If you have another invoice for the same vendor press F2 to insert the next Invoice and save the current invoice

 

Pay Vendor from Checking

Mark invoices P to Pay – double check the Select amount
Press [F7] to create a check, press A or [F7] again to create a check
Verify checking account with [OK] or Enter
Confirm Check use sequential check number or press [F10] to use an adjustment number
Confirm date of Check
Print Yes or No

 

Pay Vendor with Credit Card

Mark invoices P to Pay – double check the Select amount
Press [F12] – system will prompt for ‘vendor’ select appropriate CC Vendor Account
NOTE: this is not the same as using a Debit Card – Debit Card payments should be processed the same as a check just use [F10] in the check number field to let the system generate a number.

 

Pay Batch or Group of Vendors

Mark invoices P to Pay (use features under [F6] by due date or manually mark invoices)
Print a report to check marked vendors:
[F7] Print
D. Open Invoice Report
B. Invoices Marked for Payment
[F8] Batch
T to tag vendors to pay that were verified on the earlier report
[F8] to process – system will prompt to verify checking account, check number and date.
[Esc] to leave batch process screen when done
Print Yes or No

 

Common Tools and Reports for A/P

Accounts Payable Maintenance
Checks for duplicates, missing Vendors and verifies Vendor balances
A. Accounting Menu
I. Accounting Utilities
A. Accounting Maintenance – press any key when done, if problems show up fix them the only invoices that should show as ‘duplicate with diff amount’ are partial payments.
*NOTE: run this utility if payables checks had to be deleted also if several invoices have been deleted or moved.

Verify Payables GL to Detail Diagnostic
A. Accounting Menu
B. Accounts Payable
[F7] Print
G. Verify Payables Diagnostics – leave default ‘N’ for no on all three prompts
Difference should be ZERO 0.00

Aged Payables report
A. Accounting Menu
B. Accounts Payable
[F7] Print
C. Vendor AP Aging – verify date – Summary Aging=Y, Open Only=Y

Aging AP GL # (this should match the above mentioned Aged Payables report)
A. Accounting Menu
B. Accounts Payable
[F7] Print
I. A/P GL Aging
Verify GL, Date and leave defaults

Vendor History Detail (Audit)
A. Accounting Menu
B. Accounts Payable
[F7] Print
F. History Report

DO NOT edit or delete Previous Year Payables unless they are also edited or deleted out of the previous year. Previous Year Ending Detail and Ending General Ledger totals must match, that is what the Verify Payables GL to Detail Diagnostic checks

Other Payables and Vendor detail reports are available under the Accounting System Menu
H. Accounting Reports
A. Vendor / Payables Reports

Use [Ctrl] & [F7] in the Payables or Vendors area to customize your own report

 

Feedback
0 out of 0 found this helpful

scroll to top icon