Back to Manuals Page Home Printable Version

 

Accounts Payable

Table Of Contents

1.    Overview

2.    Enter New Vendor

3.    Enter New Invoices

4.    New Invoice Audit Report

5.    Enter Repeating Charges

6.    Convert Repeating Charges

7.    Invoice Status Lookup

8.    Change Invoice Status

9.    A/P Bank Accounts

10.  Mark Invoices For Payment

11.  Print Regular Accounts Payable Checks

12.  Manual Checks (No Invoice)

13.  Manual Check Invoice Entered

14.  Instant Checks

15.  Void Checks

16.  Purge (Delete) Paid Invoices

17.  Delete Vendors

18.  Delete Invoices

19.  Bank Reconciliation Programs 
     a) Check Register Master Entry
     b) Check Register Journal Entry
     c) Display Check Register
     d) Print Check Register
     e) Enter Cleared Items
     f) Print Outstanding (uncleared)
     g) Print Cleared Items
     h) Reconcile Bank Account
     i) Delete Cleared Items/Bal Fwd.

20.  Accounts Payable Reports
      a) Cash Requirements to Screen
      b) Aging - Detail
      c) Aging - Summary
      d) Cash Requirements by Date
      e) Cash Requirements by Vendor  
      f) A/P Check Register
      g) Vendor History
      h) Check History
      i) Long Vendor Listing

21.  Monthly Suggested Reports

22.  A/P Balance Forward Programs
      a) Enter Balance Fwd Transactions
      b) Print Balance Fwd Proof List
      c) Edit Balance Fwd Transactions
      d) Post Balance Fwd Transactions

23.  Backup AP & GL to Alt Area

 

Overview

 As in all of the BMS modules, the flow of processing is outlined on the menus themselves. If you need further help, there are help screens available in each screen. The following pages have examples of the help screens available in the Accounts Payable module. The help screens will be referred to throughout the course of this manual. In most screens, there is additional on-line more detailed help available. This will be indicated by (Press F1 for more detailed help).

There are also examples of various screens found in Accounts Payable included in this manual. These will help you become more familiar with the look of BMS module screens. Since the modules are integrated, the order entry manual will refer to other modules. To find more information on those modules, check the appropriate manuals.

As in most of the BMS modules, a few basic "rules" or keystrokes are in effect for Accounts Payable. They are the following:

All functions must be performed in CAPITAL LETTERS

<F1>=Help
<F9>=Clears screen
<Esc>=Exit
<Tab>=Find
<Backspace>=Clears the line

This manual is intended to be used as a guide in learning the Accounts Payable program. It is not a replacement for a manager's direction. This manual is not intended to teach accounting procedures. If you should have accounting questions, please seek the advice of an accountant. Some processes in the Business Management System are subjective and require specific instructions from a manager as to how your company would like a particular situation handled. Executive Computer Systems is not responsible for any actions taken based upon information found within this manual.  Top.

 

Enter New Vendor

Note: Your system is a customized system. Therefore, the menus may not have exactly the same order or options.

From the Master Menu, choose A/P - Accounts Payable System. This will bring you into the following menu:

Accounts Payable

Accounts Payable Entry/Checks
Accounts Payable Maintenance
Manual Checks & Recurring Pmt.
Accounts Payable Reports
Suggested Monthly Reports
Bank Reconciliation Programs
A/P Balance Forward Programs
Dfxpress Printer Selection
Backup AP & GL to Alt Area

 

Accounts Payable Maintenance

Enter Vendors
Change Invoice Status
Void Checks
Delete Invoices
Delete Vendor
Purge (Delete) Paid Invoices
A/P Bank Accounts

This will bring you into the screen to add your Accounts Payable vendors. You may also edit existing vendors from this screen. The following is an example of this screen.

Vendor ID: Vendor ID: This number is determined by you. This field is alphanumeric, so you can use part of the vendor name or a number that is meaningful to you. You can use this field to find existing record. Type in your vendor id or part of your vendor id and press <tab> to find it. You can also use <F5> at a blank vendor screen to look up vendors already entered. If you find the one you want to bring up, Enter on that vendor and it will bring you into the vendor screen with that account up.

Company: Company: Enter the company name. The system will not allow duplicate vendors providing you are entering the exact same name. You should do a find on the name to insure the vendor does not exist.

Address/Contact/Phone: Address/Contact/Phone: Enter the address and other information for this vendor or correct the information as required.

Vendor Terms: Vendor Terms: The vendor percentage terms can be up to 49%. For example, if the terms are 2% 10 net 30, the discount would be entered as 2%, 10 discount days, and 30 due days.

If your payments are due upon receipt with no discount, it should be 0%, 0 discount days and 0 due days. If your terms are net 30 - no discount, you should have 30 discount days and 30 due days.

SI Code: SI Code: This number can be found in a book of standard industrial codes or in some tax form

instructions. This field is optional.

Trade/Service: Trade/Service: Enter the type of service or product provided by this company. This is used for reference purposes only. This field is optional.

Default G/L Number: Default G/L Number: Enter the correct General Ledger number for this vendor. Press <F5> to view the list of General Ledger numbers.

Branch & Department: Branch & Department: Fill these in if your company uses branches and departments.

Default Invoice Description: Default Invoice Description: This field is usually where you would enter your account number for this vendor. This will print on the check stub.

Notes: Notes: Press <F8> to enter notes for this vendor. These notes are for informational purposes. This information does not print on the check stub.

Payments Elsewhere: Payments Elsewhere: A (Y) in this field will allow you to send payments to another address, such as a lockbox. If you indicate Yes here, press <F7> for the following screen.

If you indicated on the prior screen that you want to send payment elsewhere, this screen will allow you to enter another name and address for this vendor. This address will be used for all payments and 1099 forms. The presence of a SS or Federal ID number indicates the vendor is eligible for a 1099 form. A (N) answer to the send 1099 question will not prepare a 1099 form for this vendor. Enter through this screen to save your information or press <F10> to save.  Top.

 

Enter New Invoices

Once you have entered all of your vendors, you may begin to enter your Accounts Payable invoices. This screen is accessed from the main menu, then select Accounts Payable Entry/Checks.

From the following menu, select Enter New Invoices.

Enter New Invoices
New Invoice Audit Report
Mark Invoices for Payment
Enter Recurring Payments
Invoice Status Lookup
Check Printing Menu
Enter Invoices Last Fiscal Yr.
Manual Checks Last Fiscal Yr.

The following screen will appear. Read the instructions carefully to insure your information is posted correctly.

The general ledger number will be filled in from the company master record. This should have been entered during the initial company setup. See the Company Setup manual for details. If using branch/department, select which branch/department is to be used for this run. You will then need to enter a general ledger date for which you want you entries posted. The system will then ask you if you are certain this is the date you want. Answer yes and enter to continue to the following screen.

Press <F1> for Help - this displays detailed help for this screen.

Find the correct vendor by using all or part of the vendor name in the name field. If you cannot not find the vendor, press the clear key <F9> to clear the screen. Enter the new vendor information. It is very important that a search be made to verify that the vendor does not exist to avoid duplicate information. A new vendor can be created if an existing vendor was not found.

Enter the invoice number of up to 8 alpha-numeric characters. The system will give you a prompt if the invoice number you are trying to use has been used before. You can override this prompt by entering Y to continue. A "N" response will clear the screen for the next invoice. "Y" will allow you to continue.

Press <F8> to view vendor's past history. This will show you past invoices that have been entered, whether they have been paid, etc.

Enter the invoice date. The discount date and due date will be filled in according to the parameters outlined in the vendor file. These dates must be filled in, as all invoices are paid by discount date. You can override these dates and enter the date you want.

Purchase order number is the next field. This is an optional field and an entry is not required to proceed.

The default general ledger number for this vendor comes up automatically. This is the number that was assigned in the vendor file. You can break up the invoice amount among several general ledger numbers. There are no limits to the general ledger distribution for a given invoice. A list of general ledger numbers can be viewed by pressing <F5>. Once you have selected your general ledger number, press enter to get to the amount field. Enter the amount and enter. Your cursor will now go to the discount field. The discount will compute according to the vendor information. You can override the computed discount amount.

A journal transaction is created at the end of each line. Once you have entered to a new line, your entry can not be edited. If an error is made enter the next line in negative amounts to reverse the entry or add another entry to make up a difference. The general ledger numbers are verified at time of entry. Entering a credit memo is the same as an invoice, except the amount would be entered as a negative amount (-50.00).

After the last distribution is complete, press <Esc> to finish the invoice.

The cursor will now move to Autopay (Y/N). A (Y) entered here marks the invoice for payment. This invoice will be paid according to the discount date when a check run is made that includes the discount date. A (N) entered here will not mark the invoice for payment. You will have to mark the invoice for payment with the Mark Invoice For Payment program or run the Manual Checks program when you want the invoice paid. New users may want choose (N) and mark invoices through the proper program until they are familiar with the system.

Your cursor is now on the description field. The default description from the vendor setup will appear; this is usually your account number for this vendor. If there is not a description, one can be entered here. This field can hold up to 18 characters. This will print on the check stub remittance. Entering will complete this invoice. The screen will now clear and be ready for the next invoice.

DO NOT FOR ANY REASON ABORT THIS PROGRAM IN ANY MANNER OTHER THAN ESCAPING BACK TO THE MENU. ANY ABNORMAL EXIT FROM THIS PROGRAM WILL LOSE THE RUNNING TOTAL OF THE INPUT.

After entering all new invoices and pressing the <Esc> key to exit, one offsetting entry is made to the indicated accounts payable account.

The new invoice audit report must be run before the system will allow further processing of the new invoices that have been entered. By running this report, the invoices will be posted and then available to be viewed and paid. Once you have finished entering all invoices for this batch, pressing <Esc> will end session and bring up the following prompt:

Print New Invoice Audits Now ? (Y/N) __

Note: If answering "N" to this ques-
tion, you will need to print the Invoice
Audit Report from the Menu before you
will be able to Mark Invoices or Print

checks.

You can choose to run this report now or later, but remember it must be run before you can mark these invoices for payment. If you choose to run the report later, that option can be selected from the Accounts Payable Entry/Checks menu - New Invoice Audit Report. This report will list all new invoices that have been entered and will update the invoice status to autopay or not auto pay depending on your selection at invoice entry time. Invoices cannot be paid until this report is run. This is because this program will "post" these payable invoices to the proper general ledger accounts. However, it is not a substitute for an Aging Report!!!

This report cannot be rerun once it has been printed. So be sure your printer has paper. A good idea is to backup to the alternate area before printing this report. See the Backup AP & GL section for details.

The program also updates the status of the general ledger journal and prints a new invoice journal audit list for your records and review.

If you are using the Purchase Order system, Accounts Payable invoices for those purchase orders will be created automatically when the purchase orders are posted. These invoices will be accessible in Accounts Payable immediately following this posting. When the invoices are created, they will not be marked for payment. You must then use the Mark Invoices for Payment program if appropriate.

**If you should have the need to enter invoices for the prior fiscal year, you can do so by selecting the Enter Invoices Last Fiscal Yr program off of the Accounts Payable Entry/Checks menu.  Enter New Invoices program. Only difference is it will accept dates from the prior fiscal year. Please make sure you do not enter invoices in this program intended for the current fiscal year. This program should only be used by a manager or under a manager's supervision.  Top.

 

New Invoice Audit Report

This report will print each time a new batch of invoices is entered. It must be run so that the new invoices entered will be posted the appropriate vendor's account. The following is a sample of this report.

Printed 00/00/99 00:00 am Page 1

EXECUTIVE COMPUTER SYSTEMS

New Invoices Audit List

Vendor Invoice Date Discdate Duedate Amount Discount

ABC COMPANY 10000 00/00/99 00/00/99 00/00/99 100.00 0.00

BEST COMPANY 989 00/00/99 00/00/99 00/00/99 850.00 0.00

YOUR COMPANY 5205 00/00/99 00/00/99 00/00/99 1020.00 0.00

Amount 1970.00

Discount 0.00

Records Printed = 3

 

Printed 00/00/99 00:00 am Page 1

EXECUTIVE COMPUTER SYSTEMS

New Invoices Audit List

JR DATE GL BR DP DESC DEBITS CREDITS

AP 00/00/99 4400 0 0 ABC COMPANY 100.00

AP 00/00/99 6340 0 0 BEST COMPANY 850.00

AP 00/00/99 4400 0 0 YOUR COMPANY 1020.00

AP 00/00/99 2000 0 0 FROM A/P INVOICES 1970.00

Debit Amount 1970.00

Credit Amount 1970.00

Records Printed = 3  Top.

 

Enter Repeating Charges

The purpose of this program is to process recurring fixed payments, such as, rent, leases, insurance or contract payments.

This program and the check writing program are designed for payments on a monthly basis only. Any other basis for payment will have to be handled through the Enter New Invoices program.

Select Accounts Payable Entry/Checks option from main menu in Accounts Payable. Then select Enter Recurring Payments. See enter new invoice section for a sample menu. The following is an example of this screen.

Enter all or part of the vendor name. Use the find keys to find the vendor or enter a new vendor as required.

Enter the general ledger number. A list can be viewed by pressing <F5>. The number is verified. If you are setting up a new liability, the account will have to be set up in the general ledger first. Enter the description. This will appear on the check stub. Enter the amount of the payment. The next payment date will be incremented by 1 when recurring checks are printed. ie payment due 04/04/99 will become 05/04/99 when the payment is made.

The next field is "How". This is answered by a "C" or "I". A "C" answer means it will print a check on the next run. An "I" answer means it will create an Accounts Payable invoice for this recurring charge when you run the Convert Repeating Charges program. The usual response is "I" to create the invoice.

Only one payment per check run will be made. If behind in payments, more than one check run will have to be made to bring the payments up to date. Multiple payments can be made to one company on one check (not back payments). For example, multiple bank loans could be paid on one check. Enter the remaining payments (payments left to be made). Payments will stop when the number is 0. If number is unknown, ie rent, enter a large number and change as required.  Top.

   

Convert Repeating Charges

Select Manual Checks & Recurring Pmt. option from main menu in Accounts Payable. This will bring you into the following menu.

Manual Checks & Recurring Pmts

Manual Checks (No Invoice)
Manual Checks Invoice Entered
Manual Checks Audit List
Convert Repeating Charges

At this menu, select Convert Repeating Charges.

Once you have entered the appropriate information, it will generate a new invoice audit report for the invoices created and post the information to the appropriate accounts. If it is the first of the month your date range should be 12/01/99 - 12/31/99 to include all charges within that month.  Top.

 

Invoice Status Lookup

This program is used to view entered invoices for any vendor. It will show you paid, unpaid, scheduled (marked for payment) and unscheduled.

Select Accounts Payable Entry/Checks option from main menu in Accounts Payable. Then select Invoice Status Lookup from this menu.

At this point, select what invoices you want to see - paid, unpaid, scheduled, etc. and Enter. The screen to select the vendor you wish to look for will appear next.

Once you have selected the vendor you wish to view, press Enter to list all invoices for that vendor. The invoices will show per the criteria you selected initially.

If there are more than twenty invoices, you can enter "M" to see more. If you need to view the invoices again, type "L" to relist the invoices. The code field will show various codes: P=Paid, Y=Scheduled for payment, N=Unscheduled, U=Unscheduled, S=Scheduled for payment. The U and S codes are changed to Y or N when you run the new invoice audit list. If the invoice is paid the due date will be the payment date.

Once you have finished looking at the information you selected, press <F9> to clear the screen and select another vendor. If you are finished and wish to exit the program, press <Esc> to take you back to the menu.

This program does not print a report.  Top.

Change Invoice Status

This program lists all unpaid invoices for the selected vendor. Once you have found the invoice you want to change, the program will allow you to make certain changes. The most important change that can be made from this screen is to unmark an invoice for payment. Select Accounts Payable Maintenance option from main menu in Accounts Payable. Then select Change Invoice Status from this menu. The following are examples of the screens in this program.

Find the vendor in the name field with the find keys. Once you have found the vendor you want, press enter to list the invoices. The following is an example of the next screen.

Only the dates can be changed in this program. If the invoice is marked "Y" (scheduled to be paid), it can be changed to "N" (unscheduled). You cannot mark invoices for payment in this program, only unmark. If the invoice being edited was marked for payment and is changed to unscheduled, the pay and discount will return to zero.

If you need to correct an amount of an invoice already entered, you will have to delete it by using the Delete Invoices program. Once you have deleted, you would then re-enter it using the Enter New Invoices program.

This program will not print a report.  Top.

 

Delete Invoices

This program will allow you to delete invoices that have been entered into the system, either via Enter New Invoices program or through the Purchase Order program. Select Accounts Payable Maintenance option from main menu in Accounts Payable. Then select Delete Invoices from this menu. An example of this screen is as follows.

Once you have selected your general ledger date, the screen to select a vendor will appear.

Find the correct vendor by using all or part of the vendor name in the name field. This screen works just like the mark for payment program, except you are selecting the invoice to delete. Invoices that have been marked for payment cannot be deleted. You must unmark the invoice with the Change Invoice Status program before you can delete. After you have selected the invoice to delete, the invoice distribution screen will appear.

Make the same distributions to the general ledger as the original posting of new invoices. The system will reverse the sign on the amounts. The discounts do not need to be posted.

The general ledger number will be filled in from the company master record. If using branch/department, select which branch/department is to be used for this run. Also see system overview on branches/departments.

Enter the general ledger distribution for the invoice. The distribution should be the same distribution made when you entered the invoice. The system will default to a credit entry. This is normal for reversing journal entries created during invoice entry. For deletion of credits, change C to D for debit. When totals are equal the system will return to prior screen. Totals must equal to continue.

If you have finished making entries, press <Esc>. This will bring you back to the menu. This program will print a report of all invoices that were deleted.  Top.

 

Mark Invoices For Payment

Marking invoices for payment needs to be done if you intend to have the system print checks. (Manual checks cannot be done if the invoices are marked for payment.) What you are doing in the Mark Invoices for Payment program is telling the system which invoices you want paid when you run regular checks. Select Accounts Payable Entry/Checks option from main menu in Accounts Payable. Then select Mark Invoices for Payment from this menu. The following is an example of this screen.

The vendor can be looked up by either typing in part or all of the name and pressing the <tab> key, or the page up and down keys. You can also use <F7> to display all vendors. Remember, the vendor may have been entered under another spelling. If you have found the wrong vendor, press <F9> to clear the screen to find another vendor.

All invoices not marked for payment will display. If there are more than 9, arrow back up to the field and type "M" to view the rest. If you ask for more and want to go back to the beginning, arrow back up to the field and type "L" for the system to relist invoices.

Select the line number to pay. The amount owed will display as the amount to pay. If allowed the discount amount will display in the discount field. If taking a discount, enter the full amount being paid (do not deduct discount) as the amount to pay. Enter the discount as a separate entry in the discount field. The system will subtract the discount taken at check writing time. The system may beep if you are past the discount date, but it will still allow you to take the discount.

Partial payments are allowed. Change the displayed amount to the amount you wish to pay.

After marking the last invoice for a vendor, press <F9> to clear the screen and return to the top. Press <Esc> at the top to end. Press Enter to Return

This program does not print a report. If you wish to see a report of what invoices have been scheduled or marked for payment you can run a Cash Requirements report.   Top.

 

Print AP Checks

This program is used to print your payments through the system. This can be used with continuous feed checks or laser checks. You should select your check type at the time of setup. To use this program, select Accounts Payable Entry/Checks option from main menu in Accounts Payable. Then select Check Printing Menu from this menu. This will bring you into the following menu.

AP Check Printing Menu

Print Regular AP Checks
Reprint Individual AP Check
Direct Disbursements (Inst Cks)
Instant Check Audit List
Recurring Payment Checks

Once you have selected Print Regular AP Checks, you will be brought into a screen which gives you the option of backing up to an alternate area before running the print checks program. It is extremely important to backup to an alternate area before running this program. See the backing up AP & GL section for details. If your checks should jam or you should have any kind of problem and you have not backed up - you may lose your information. The backup to an alternate area keeps your information intact so if there is a problem the information can be restored.

After backing up to an alternate area, the program will next take you into Align Checks. This program will allow you to print test checks to make sure all information is aligned properly before you run the actual check program. This should be run when using continuous feed checks. It is not necessary when using laser checks.

Next, you will go into the actual Check Printing program. The following is an example of that screen:

The check writing allows 17 entries on the remittance portion of the check. If there more invoices are being paid, a second or more check(s) will be prepared. The program will void the first check and print the second check for the full payment amount. It is recommended that a Cash Requirements report be run prior to printing checks. This will let you know what and how much is being paid. Make sure you use the same discount date for both the check writing and the cash requirements reports so your information will match.

Bank Account: Bank Account: The G/L for the bank account is displayed from the Bank setup file. Enter the branch and department if being used. The G/L number is verified and must exist.

Starting Check Number: Starting Check Number: Enter the number you want printed on the first check. The program will print this check number regardless of what is pre-printed on your checks. Make sure if you have pre-printed checks to start with correct check number.

Discount Date: Discount Date: Enter the discount date to pay through. The program pays based on the discount date. If you want to pay all invoices marked for payment and due on 3/10/99, enter the date as 031099. All checks will be printed that have a discount due date on or before the date entered. If discounts are taken, there will be two summary journals created. One to the proper accounts payable accounts and the second to the discount taken account.

on or before the date entered. If discounts are taken, there will be two summary journals created. One to the proper accounts payable accounts and the second to the discount taken account.

General Ledger Date: General Ledger Date: Enter the G/L date (period) that you want the check transactions posted to. You can have a current check date, but post cash entry to a different date.

Check Date: Check Date: Enter the check date you want on the checks.

Branch/Department: Branch/Department: When the check run is complete, the system will make one offsetting entry to the bank account for all checks processed. Therefore, it is critical to only run checks for the proper branch/department if doing branch/department accounting.

Once you have entered all information, enter (C) to continue or (A) to abort program. Continue to run your checks or Abort to escape from the program without running checks.

If you should need to reprint a check, that selection is available from the Check Printing Menu. The program is Reprint Individual AP Check. You may need to reprint a check if it was damaged during or after the printing process. The following is an example of this screen.

Enter the check number of the check you wish to reprint. The vendor information should appear. If the information is correct, enter the new check number. The new check number will replace the old check number in the appropriate areas. Choose Continue to reprint your check. Make sure checks are in the printer and the printer is ready. Press <F1> for help in this screen.

This program allows reprinting of checks, one at a time. It will change the check number in the invoice record, general ledger record and bank reconciliation records to reflect the new number. If an invoice was paid in error, do not use this program. The program for that situation is "Void Checks", which will void the check and mark the invoice records as not paid.  Top.

 

Manual Checks (No Invoice)

The manual check (no invoice) program is not to be confused with Marking Invoices for Payment. A manual check is a check that was previously handwritten to pay an invoice or to pay for something without having the invoice. This program is for after-the-fact paid invoices or a check written on the fly and not entered in the system. To enter the check and the invoice at the same time use the Manual Checks (No Invoice) program. Only use this program when necessary. Otherwise, enter the invoice and pay through Manual Checks (Invoice Entered). Select Manual Checks & Recurring Pmt. option from main menu in Accounts Payable. This will bring you into the following menu.

Manual Checks & Recurring Pmts

Manual Checks (No Invoice)
Manual Checks Invoice Entered
Manual Checks Audit List
Convert Repeating Charges

Once you have selected, Manual Checks (no invoice), you will be brought into the following screen:

MANUAL CHECK ENTRY

CASH ACCOUNT ENTRY

G/L BRANCH DEPARTMENT

G/L DATE 00/00/99  CHECK TO SEE IF INVOICE ALREADY PAID?__

Enter the general ledger bank account number from which you are writing this check. You can select the option to make sure the invoice you are selecting is unpaid, just in case it was already entered. After you have selected the general ledger information, you will be taken into the following screen:

This screen is the same as Enter New Invoices program. When you have brought up your vendor and have entered the invoice information, you will <Esc> to finish. At this point another screen will pop up for you to enter the payment information. The following is a sample of that screen.

CHECK DATE :
CHECK # :
CHECK AMOUNT:
CHECK CLEARED? (Y/N)

Enter the check information at this time. If your check has already cleared, then enter "Y". If not or you are not sure, enter "N". Once you have finished entering all manual checks, press <Esc>. At this time you will be asked if you want to print the report. You should print it at this time but can choose to print it later. This report will give you a manual check report showing the vendor, invoice #, invoice date, date paid, amount, bank account number and check #. The second part of this report will print general ledger information for these transactions.   Top.

 

Manual Checks Invoice Entered

The manual check invoice entered program is not to be confused with Marking Invoices for Payment. A manual check is a check that was handwritten to pay an invoice. This program is for invoices that were not paid during a regular check run but were paid by manual checks. The invoices should have already been entered in the system through the Enter New Invoices program. You can then pay the invoices with this program. This program is good for a company just starting to use the system.

Select Manual Checks & Recurring Pmt. option from main menu in Accounts Payable. This will bring you into the following menu.

Manual Checks & Recurring Pmts

Manual Checks (No Invoice)
Manual Checks Invoice Entered
Manual Checks Audit List
Convert Repeating Charges

When you select Manual Checks Invoice Entered, you will be brought into the following screen:

Once you have entered the appropriate information for this screen, the following screen will appear:

The vendor can be looked up by either typing in part or all of the name and using the find, enter or page up and down keys. Remember, the vendor may have been entered under another spelling. If you suspect you have found the wrong vendor, press the clear key to clear the screen to find another vendor.

All invoices not marked for payment will display. If there are more than 9, you can type "M" to display more. If you ask for more and want to go back to the beginning, type "L" for the system to relist invoices. If the invoice you are looking is not listed, check to see if it was marked for payment or paid already by using the <F8> key to Lookup Vendor Invoices.

Select the line number to pay. The amount owed will display as the amount to pay. If allowed the discount amount will display in the discount field. If taking a discount, enter the full amount being paid (do not deduct discount) as the amount to pay. Enter the discount as a separate entry in the discount field. The system will subtract the discount and show the correct total in the check amount field. Verify the check amount showing in that field. Enter the check number and date. If you are finished with this transaction, <F10> will save it and clear the screen for the next transaction. If you wish to clear without saving the information, press <F9> to clear.

If you have written a single check paying multiple invoices, do not save your transaction yet. Simply select the next line number to pay, indicate the amount to be paid on that invoice, enter the discount, then just return through the fields. The check amount will increase in the "check amount" field. Hit enter through the check number and date. Continue this procedure until all the invoices on that same check are selected. At that point, <F10> to save the transaction.

If you have written separate checks for separate invoices, but for the same vendor, enter the information for the first check. When the cursor goes back to the line number, press <F10> to save your current transaction. Then bring up this vendor again and continue as normal.

Partial payments are allowed. Change the displayed amount to the amount you wish to pay. You cannot pay invoices that are not in Accounts Payable or ones that are marked for payment.

After saving the last entry, press <F9> to clear the screen and return to the top. Press <Esc> at the top to end. Upon exiting this program, a transaction report will print. The system will warn you that the report will be printed, so have your printer on and ready. This report will give a detailed listing of all manual checks entered at this time.  Top.

Direct Disbursement / Instant Checks

Instant checks are just that. The program allows you to enter an invoice "on the fly" and pay it with a check at the same time. Enter a new invoice and print out a check. To access this program, select Accounts Payable Entry/Checks option from main menu in Accounts Payable. Then select Check Printing Menu from this menu. Then select Direct Disbursement (Inst Cks). This will bring you into the following screen.

Check to see if invoices have been entered already - answer yes or no. This will only check if invoice number is greater than 0. Note: If starting a new fiscal year, make sure the G/L has been set up.

The cash account G/L number will be displayed. Enter the Branch & Dept. you are working with, if any. Enter the G/L date, the check date and the beginning check number. The general ledger date can be different from the system date. Invoices received and paid in one month can be distributed to a different accounting month.

Once you have gotten into the program, the next screen you will see looks exactly like the screen to enter new invoices. The following is an example of this screen.

Upon completion of the invoice distribution, the system will generate a check. If generating instant checks where separate bank accounts are used for either the branches or departments, exit this program and start over for each bank account.

An unlimited number of general ledger distributions can be made on any invoice. Press <Esc> when you have finished the G/L distributions. Your cursor will now be on the description field. A twenty character description can be entered for printing on the check. You may want to put your account number for this vendor in this field.

If there is only one invoice to print on this check answer "Y" to the last invoice question. A "N" response will clear for another invoice to be entered. Seventeen invoices are permitted on a check. Enter when you are done. Your check will now print. The system will bring you back to the vendor screen. You can enter more instant checks at this time. Press <Esc> if you are done.

An invoice record is created with this program and can be viewed in the Invoice Status Lookup program. The invoice record is not available through the Purchases Journal report. The void check program will void this type of check.

Once you have finished running this program, you can print out an Instant Check Audit List. This will print out the information for the invoices you entered and paid. It is recommended you print this report to keep for accounting purposes.  Top.

 

Void Checks

This program allows you to void a check. This voided check will appear in the Check Register. It will also restore the invoice information for what paid by this check. These invoices will be back in the system as unmarked and unpaid. To access this program, select Accounts Payable Maintenance option from main menu in Accounts Payable. Then select Void Checks from this menu. The following are examples of the screens for this program.

Enter the general ledger number and branch and department if any. Enter the check number you wish to void. Press the enter key. The vendor information will display when the record is found. If information is not found for the check number you entered, the cursor will jump back to bank account number.

If the check information is correct, enter the general ledger date for which you want to void the check. Choose "C" to continue or "A" to abort. If you have entered incorrect information or just want to get out of this program, you must enter through to Abort properly. Escape will not abort. If you have chosen "C" to continue, the following screen will appear.

All invoices paid on the selected check number will display. Make sure that the invoice information that is listed is correct. When you have completed the voiding process, these invoices will be unpaid and unscheduled (unmarked). If you want them marked for future payment, do this through the Mark Invoices for Payment program. If any of the invoices were paid as a result of having the wrong discount date, correct the discount date through the invoice correction program.

The system will show you the total and ask if this is okay. Select "Y" if this is correct and enter. The system will then tell you to print the report. The program will create three general ledger journal entries for each check voided. One to debit the bank, one to credit accounts payable and one for any discounts taken.  Top.

 

Purge (Delete) Paid Invoices

This program will delete all paid invoices that have been paid prior to the date entered. Check with a manager or your accountant to determine how long the information should be kept before it is deleted. To access this program, select Accounts Payable Maintenance option from main menu in Accounts Payable. Then select Purge (Delete) Paid Invoices from this menu.

No other purge operation or accounts payable operation should be performed while this program is processing. Once this program is started do not stop it for any reason or valued information will be lost. If you have not made a backup of the Accounts Payable files, abort the program and do a backup to alternate area first. See the Backup AP & GL section for details.

A report will print. You can output this report to the screen or the printer. A printed report is recommended for audit purposes.

If you wish to exit the program, Enter (A) at the prompt to abort. If you have run the program without intending to, the information can be restored provided you backed to alternate area prior to running the program. If you did not backup the information can only be restored from some other type of backup which may not include all information.

This program should be run by a manager or under a manager's direction.   Top.

 

Delete Vendors

This program will allow you to delete a vendor and assign the information to another vendor. To access this program, select Accounts Payable Maintenance option from main menu in Accounts Payable. Then select Delete Vendor from this menu. The following is an example of this screen.

This program is used to delete vendors. Be careful in the use of this program! Because there are records in the invoice file, the recurring payment file, and the history files that may be assigned to the vendor, this program will assign all records found for the deleted vendor and assign them to the second vendor.

Enter the vendor number that you want to delete and the vendor number you want to assign the transactions to. The program will find the vendors, transfer the transactions and delete the old vendor. If you are transferring to a new vendor, make sure they have been already setup in the Enter Vendors program.

There are no reports that are generated by this program.

This program should be run by a manager or under a manager's direction.   Top.

 

A/P Bank Accounts

This program will allow you to setup which bank account from which you want to write checks. You may enter any bank from which you will be working. To access this program, select Accounts Payable Maintenance option from main menu in Accounts Payable. Then select A/P Bank Accounts from this menu. The following is an example of this screen.

Before you can do any check writing (manual or automatic), you need to set up the cash (bank) account(s) that you will use for check writing in the General Ledger system. This is so that when you are prompted for the A/P Bank Account number after a marking checks or manual checks, the system will only let you access actual bank accounts. In other words, you will not be able to write a check from your "Inventory" G/L Account.

To Add Bank Accounts:
Press <F9> to clear the screen. Move the cursor to the GL Acct Field. Use Page Up and Page down to find the General Ledger accounts you want to use for Accounts Payable check runs. Press enter to get to the next check #. Press <F10> to save your selection. These must be valid G/L accounts in order to add them here.

To Delete Bank Accounts:
Your cursor should be on the Number field. Use Page Up and Page Down to find the accounts you do not wish to use for Accounts Payable check runs. Press <F6> to delete.

There are no reports that will be printed. Any bank accounts added here will be accessible immediately.  Top.

 

Bank Reconciliation Programs

Select Bank Reconciliation Programs option from main menu in Accounts Payable. This will bring up the following menu. This program has several steps involved. The following screens are examples of the steps in the bank reconciliation program in order of the menu.

Bank Reconciliation

Check Register Master Entry
Check Register Journal Entry
Display Check Register
Print Check Register
Enter Cleared Items
Print Outstanding (uncleared)
Print Cleared Items
Reconcile Bank Account
Delete Cleared Items/Bal Fwd.

The following are descriptions of all the programs available in the Bank Reconciliation menu. These programs should be used by a manager or under a manager's direction. The information should also be backed up to an alternate area before making changes to the data. See the Backup AP & GL section for details.  Top.

 

Check Register Master Entry

This program allows you to make entries into the check register that did not go through the system. These entries may be a balance forward for a new bank account, a check that was never used but you need to track it or another similar situation. This program does not make journal entries to any other accounts. It will only put the information into the check register. The following is an example of this screen.

Select the bank account you are working with by either entering the number and pressing <tab> or pressing <F5> for a popup list. Enter the reference number, which would be the check number or some other reference like a date. This should be a unique number. Enter the date of the transaction and a description, maybe voided check. The type would be a minus for a check or credit, a plus for a deposit or debit, or a balance forward. Type in the amount of the transaction. You may choose to mark this item as cleared from this screen if it has already cleared your bank or is a voided check. Entering through the screen or pressing <F10> will save this transaction. To clear the information without saving, press <F9>. You can delete an entry by pressing <F6>. Make sure this is what you want to do before deleting.  Top.

 

Check Register Journal Entry

This program will allow you to make entries in the check register that have a journal transaction for the selected bank account that for whatever reason, did not get entered. This program can be used to record interest earned in a bank account or something similar. It will then allow you to make the corresponding journal entries to debit and credit the proper general ledger accounts. The following is an example of this screen.

This is similar to the Check Register Master Entry program with the exception it will allow you to input journal entries. Enter the general ledger number for the bank account you are using. The cursor will then move to the reference field. Enter the check number or date or some other reference; this should be a unique number. Enter the date of your transaction and a description. Use type "1" for a check or credit and type "2" for a deposit or debit. Enter the amount of the transaction. Once you have entered an amount, you will then be in the journal entry screen. The following is an example.

At this point you would enter your journal entries. Enter the source journal. A source journal can be CD for cash disbursements, CR for cash receipts, etc.. The following is an example of the selection of source journals.

Journal Codes:

AP - Accounts Payable
AR – Accounts Receivable
CD – Cash Disbursements
CR – Cash Receipts
GJ - General Ledger
PR – Payroll
SJ - Sales Journal

Next enter the starting date. The starting date is the first day of the month you are making entries. So if you enter 07/01/99 for the start date, you can then put "03" for the date and the transaction will be recorded for July 3. Enter your transaction date. Next the cursor will go to first general ledger number. Enter a general ledger number or <F5> to select one from the popup list.

Enter the rest of the information on each line item that follows. Next is the description, amount (always positive), whether the transaction is a debit or credit, and reference #1 (check number) and #2 (this could be some other reference number). Each line entry will create a journal entry unless no amount is entered on that line. The journal transaction is saved after pressing the enter key at the end of the line. If a mistake is made, enter a reversing entry on the next line or <F3> to edit the previous line. You will notice that the system keeps track at the bottom of the screen whether you are in balance or not.

Every line creates a journal transaction and once you exit this program they can only be edited in the Correct Posted Journal Entries program found in the General Ledger menu. This program will allow you to enter a one-sided journal entry. It will not give you a message if you are out of balance before saving these transactions.

When you enter the last transaction for this check register entry, press <Esc> to exit back to the check register master entry screen. You will then be asked if you want to save this entry. Choose "Y" to save. A journal transaction will still be created if you answer No to this question but the entry to check register will not be saved. A journal entry report will then print.

Please be advised, if you are making a journal transaction between two bank accounts, this program will only record the check register entry for whichever bank number you originally chose. To make the check register entry for the other bank account, use the Check Register Master Entry program. You do not have to enter the journal entries again. They will have been made for both sides of your entry provided you have entered that information.  Top.

 

Print/Display Check Register

This program will print/display the check register to the screen for the selected bank account. You can view all checks, deposits and other entries that have been made in the check register. This can be printed or viewed either by date or by reference number (which is the computer's internal number assigned to all accounts payable transactions. The following is an example of the screens for check register by date.

Once you have selected the bank account, the following screen will appear.

This screen displays the check register information for the selected bank account. This will display the checks paid, deposits made and the balance after each entry. The T column will show a 1, 2 or 3 which would be 1=check/credit, 2=deposit/debit or 3=balance forward. The status column will show whether the transaction is "H" held, "C" cleared, or blank for not cleared. At the end of all entries, the system will display the checkbook balance as of the date of the last transaction recorded.   Top.

 

Enter Cleared Items

This program will allow you to enter the items that have cleared through your bank account. This is one of the first steps in reconciling your bank statement to your checkbook. The following is an example of this screen.

Select the appropriate bank account and Enter. The cursor will bring you to the "Cleared, Held or Release" field. A cleared item is one that has cleared through your bank. A held item is one you have processed but are holding; this has not gone through your bank. Release will release the items you have placed on hold. These can then be entered as cleared. Enter your selection and press Enter. The cursor will then bring you to the reference field. Enter the reference number or check number of the item you want to clear and Enter. The information for that check will appear. Verify that this is the item you want to clear. If it is and the status is C for cleared or the appropriate status for what you are doing, then enter through or <F10> to save the entry. Continue to enter items or <Esc> to exit the program.

There are no reports that will print. Pressing <F8> from this screen will display the check register. Items that have been marked clear, held or release will have these codes displayed in the check register screen under the "STAT" field.  Top.

 

Print Outstanding (Uncleared)

This program will print all outstanding or uncleared items in the check register. This report will print according to a selected date range and bank account.

This report will print immediately so make sure your printer is ready.   Top.

 

Print Cleared Items

This program will print all cleared items in the check register. This report will print according to a selected date range and bank account. The following is an example of this screen.

The report will print immediately so make sure your printer is ready.   Top.

 

Reconcile Bank Account

This program will reconcile the selected bank account. The following is an example of this screen.

You should have made all of your entries for the check register in the Check Register Master Entry program or the Check Register Journal Entry program and the Enter Cleared Items program prior to reconciling your bank account.

First select the bank account you want to reconcile. Your cursor will then go to the Checks/Deposits Before field. This is asking you for the date up to when you want to the computer to search for information. This should be your statement ending date - usually the last day of the month.   Enter the beginning statement balance. This number should be the balance forward from last month's reconciliation. The program will then search for the bank information. It will fill in the information according to what deposits/checks/entries were cleared through the system, etc.

You can access the Cleared Item program by pressing <F6>, the Check Register Journal Entry program by pressing <F7> and the Check Register Master program by pressing <F8>. Use these features to enter any forgotten or missed entries to the check register.  If the reconciliation amount is incorrect answer no at the bottom of the screen.  You can then press <Esc> and the cursor will go back to menu.  Make any changes or entries you need and go back into the reconciliation program to finish.   Once you have an accurate finished to the reconciliation, run the Delete Cleared Items/Bal Forward programTop.

 

Delete Cleared Items / Bal Fwd.

This program will delete all check register items that you have cleared. It will also create a balance forward for the deleted cleared items. This will update your check register. This program should only be run after you have reconciled your bank account. The following is an example of this screen.

Select the bank account you have reconciled. You will then be asked for a balance forward date. This should be the statement ending date of your reconciliation. The program will process the transactions and delete the ones for this selected date. Backup to an alternate area before running this program. See the Backup AP & GL section for details. When the program is finished, a message will appear stating the program is done. As previously stated, a balance forward entry will then be created in the check register. To exit this program once it is done processing, press any key.  Top.

 

Accounts Payable Reports

Select Accounts Payable Reports option from main menu in Accounts Payable. This will bring you into the following menu.

Accounts Payable Reports

Cash Requirement to Screen
Aging - Detail
Aging - Summary
Cash Requirements by Date
Cash Requirements by Vendor
A/P Check Register
Vendor History
Check History
Long Vendor Listing

The following are examples of the program screens for each of the accounts payable reports from the above menu.  Top.

 

Cash Requirements To Screen

This report will display a listing of all invoices due by the selected date range. This will give you a total so you have an idea of the cash required to pay all invoices listed. You should run this report before marking invoices for payment and doing a check run. It will give an idea of what you can pay at this time. The following is an example of this screen.

You can run this report by what invoices are scheduled (marked for payment), unscheduled or both. Select your due date and then the date by which you wish to age the invoices. This report will display to screen. If you wish to print this report, you can run the Cash Requirements by Vendor or by DateTop.

 

Aging - Detail

This program will print a detailed accounts payable aging report by discount, due or invoice date depending on the selection you make. All invoices are current until the first day after the selected reporting date. Invoices with a date later than the system date will not be included. The option to ignore the G/L date will include all invoices that qualify, regardless of when entered. The following is an example of this screen.

Choose "C" to continue or "A" to abort. The report will print immediately after continuing, so make sure your printer is ready.  Top.

 

Aging - Summary

This program will print a summary accounts payable aging report by discount, due or invoice date depending on the selection you make.

Vendor and totals are shown, not the individual invoice detail. Invoices with a date later than the system date will not be included. The option to ignore the G/L date will include all invoices that qualify, regardless of when entered. This report will print immediately after continuing, so make sure your printer is ready.  Top.

 

Cash Requirements By Date

This report will show you how much cash you need to pay all invoices due by a selected date.

Scheduled Invoices are those invoices that have been marked for payment. This could have occurred at the time the invoice was entered or through the program to mark invoices for payment. Unscheduled Invoices are entered, but not yet been marked for payment.

This report lists invoices by selected options by date. The options are:

(S) Schedules Invoices: Invoices marked for payment.

(U) Unscheduled Invoices: Invoices not scheduled for payment.

(A) All Invoices: Both Scheduled and Unscheduled.

(D) Detail: Will list the invoice & detail.

(T) Total: Will print only totals by date.

The cash requirements program builds a temporary sort file. When the sort is completed, the report prints and clears the temporary file. If for some reason, such as the printer not turned on or the program is aborted prior to printing, the same data will appear on the report the next time it is run. You can clear the file by printing the report again. Then reselect and do again.  Top.

 

Cash Requirements By Vendor

This report will show you the cash you need to pay all invoices by a selected vendor by a selected date.

You will get a listing of all checks paid. You can select the check number to start with if you want, and also select within a specific date range. You must enter either a check number or a date range, otherwise no report will print. If you want all checks from the beginning of your records, enter 01/01/80 through 12/31/99.  Top.

 

A/P Check Register

This program will print a check register by the information selected. The following is an example of this screen.

 

Enter the starting check number or just enter to continue. This should be the same number as the beginning number used for the check printing run if you are using the register to compare. Entering the beginning check number will speed up finding the first valid record. If guessing, make sure to guess a lower number than actual.

Enter the date of the first check and the date of the last check. Enter the branch and department or (A) for all. This report can go to the printer or to the screen. Use <F5> to make the appropriate changes. The report will print immediately, so make sure your printer is ready.  Top.

 

Vendor Payment History

This program allows you to review paid invoices by vendor in vendor invoice number order within a selected date range.

Select the branch or department you are working with, if your company uses them. Then select the source code of how the invoice was paid. The following are the source codes you can choose from. Source Codes: 0 = Regular, 1 = Rebates, 2 = Instant Checks, 3 = Recurring Payments,

4 = Interest, 5 = Manual Checks or A = All. Once you have made these selections, press Enter and the vendor selection screen will appear.

Type in part of the vendor name and press <tab> to find. Use the page up and down keys to find the correct vendor. Enter the date from which you which to start searching. The screen will list the invoice numbers, purchase orders numbers, invoice dates, bank account with the check numbers, dates and amount paid. It will also total the invoices within the date range you selected. To select another vendor, <F9> to clear and enter the new vendor. Press <Esc> to exit. You can print this information by pressing "P" to print.  Top.

 

Check History

This program will display a list of invoices paid and the payee on the check for the selected check number from the selected bank account. The first screen will allow you to specify the bank account from which the check was paid. The following is an example of the next screen.

Enter the check number and Enter. The check date and all invoices that were paid on this check will be listed. The total for the invoices, discount (if any), and the check amount will be listed. Voided checks will show as negatives. If you need to print the information, choose "P" and enter. <F9> will clear the screen for another check selection. Press <Esc> to abort the program.  Top.

 

Long Vendor Listing

This report lists all your vendors alphabetically, includes name and address, phone numbers, contacts, and trade/service.

Choose "C" to continue and print the list or "A" to abort and exit the program.  Top.

 

Suggested Monthly Reports

The following are some reports that we suggest you run at month end. These are for accounting purposes and make be some information your accountant will want to see. Check with your accountant to see if there are any other reports your company should run at month end.

Suggested Monthly A/P Reports

Detailed Aging
Purchases Journal
Check Register

See the sample screen for Detailed Aging report and the sample screen for Check Register report