Sage 100 Accounts Payable Data Conversion

From another System

Gather the appropriate information and follow these steps:

1. Gather all unpaid invoices as of your last closed accounting period.
2. Run a report from your current system or prepare an adding machine tape totaling the invoices. This amount should equal the account balance for the accounts payable account(s) in General Ledger.
3. Set the accounting date to the last day of the last closed accounting period. This is the current period established in Accounts Payable Options.
4. Enter 1099 payments in the current calendar year.
5. In Invoice Data Entry, enter the outstanding balance amounts for each invoice using the original invoice dates. During the distribution process, post the entire distribution balance to your accounts payable account number in General Ledger.

Note: Do this when you have expensed these invoices in the previous system.

6. Print the Invoice Register from the Main menu. The total should equal the balance of the accounts payable account in General Ledger.
7. Update the Invoice Register and the Daily Transaction Register.
8. Run Full Period End Processing to clear the month-to-date purchases fields and forward to the next period.
9. Reset the accounting date to the first day of the current accounting period.

Linking Accounts Payable to Accounts Receivable

• Vendor / Customer Link Maintenance
• AP form AR Clearing Selection
• AP form AR Clearing Entry
• AP form AR Clearing Register

Are you interested in learning about Converting Accounts Payable to Sage 100 from Another System? Accounting Business Solutions by JCS offers Sage 100 training classes, including Converting Accounts Payable to Sage 100 from Another System.  Call us today at 800-475-1047 or email us at solutions@jcscomputer.com today to get started.

Learn how to maintain Sage 100 Accounts Payable and Sage 100 Accounts Receivable with Sage 100 training classes from Accounting Business Solutions by JCS!

One of the most attractive features of Sage 100 is its flexibility, and the Sage 100 Accounts Payable module and Sage 100 Accounts Receivable modules are no exception. Sage 100 Accounts Payable Maintenance and Accounts Receivable Maintenance contains a variety of options which can be customize to fit your particular needs.

Division Maintenance

• GL Accounts are assigned
• Leave Cash Account blank to assign by bank code
• Use 00 (default) for no divisions
• You must enter an Accounts Payable and Discounts Earned account to avoid missing or invalid general ledger account errors when updating.

Bank Code Maintenance

• A is default bank code
• Bank Code Beginning Balances are entered through Bank Reconciliation
• After a bank code is defined and the integration to Bank Reconciliation is selected, transactions using a bank code are updated to Bank Reconciliation.

Terms Code Maintenance

• 00 is default terms code

Sales Tax

For calculation of sales tax in AP or PO

• Sales Tax Class Maintenance
• Sales Tax Code Maintenance
• Sales Tax Schedule Maintenance
• Sales Tax Account Maintenance

ACH Interface Maintenance

Memo Manager Maintenance

• Assign security roles to where memos can be created / viewed

Learn how to use Sage 100 Accounts Payable Options with Sage 100 training classes from Accounting Business Solutions by JCS!

One of the most attractive features of Sage 100 is its flexibility, and the Sage 100 Accounts Payable module is no exception. AP in Sage 100 has a variety of customizable options which range from sales tax reporting and aging options to printing and batch processing options. Continue reading to see the various customizable screens in Sage 100 Accounts Payable.

Accounts Payable Options – Main

• Divisions
• Aging
• Sales Tax Reporting
• Integration

Accounts Payable Options – Additional

• Posting
• Comments
• Invoices paid on or before the number of days entered are purged automatically during period-end processing.
• Other

Accounts Payable Options – Entry

• Batch Processing
• Defaults
• Resets

Accounts Payable Options – Printing

Accounts Payable Options – History

Accounts Payable Options – ACH

Correctly setting up Sage 100 Accounts Payable is crucial to your Sage 100 success. Learn how to set up Sage 100 Accounts Payable here!

What’s needed for AP setup

Before using Accounts Payable for a new company, you must complete the Accounts Payable system startup process. Before beginning the system startup process, gather the following information:

• Your general ledger chart of accounts
• A list of states, counties, and local areas to which you report sales tax and their tax rates
• Your bank account number(s) for the checking account(s) used by Accounts Payable
• A list of standard payment terms offered by your vendors
• A list of vendors, including addresses and phone numbers
• All unpaid invoices at the time of installation

Steps for setting up Sage 100 Accounts Payable

1. Enter the Company Code
2. Enter Accounting Date
3. Complete the Accounts Payable Setup Wizard
4. Define Accounts Payable Options
5. Division Maintenance
6. (Bank Code Maintenance)
7. Terms Code Maintenance
8. (Sales Tax Class Maintenance)
9. (Sales Tax Code Maintenance)
10. (Sales Tax Schedule Maintenance)
11. (Sales Tax Account Maintenance)
12. (Memo Manager Maintenance)
13. Vendor Maintenance
14. Beginning Balance Entry
15. Open Invoice Entry
16. Print Invoice Register and Update
17. (Set-up Repetitive Invoice Templates)
18. Daily Processing

Are you interested in learning how to set up Sage 100 Accounts Payable? Accounting Business Solutions by JCS offers Sage 100 training classes, including how to set up Accounts Payable in Sage 100.  Call us today at 800-475-1047 or email us at solutions@jcscomputer.com today to get started.