Accounts Receivable Basic Procedures

Importing Remittance Data

This feature lets you import check remittance information and post it to accounts receivable. You may receive this data from an individual customer or from a bank. Banks view the check stub or remittance attached to the check and manually enter the information in a spreadsheet. When you receive the spreadsheet, you can import the details into A/R.

Note: To successfully import remittance information, the spreadsheet you use must contain the correct data and be properly configured. For details, see About Importing Remittance Data Using an Excel Spreadsheet.

1. Double-click .

2. Click the Action menu and select Import Remittances.

3. When the Batch Information dialog box opens, specify the batch number for this posting.

4. The Control G/L box displays the general ledger control number for this posting. This information comes from the A/R Control field in the (L2) G/L Master Numbers screen. This is the general ledger account for the accounts receivable balance, if you are live on general ledger. We recommend you accept the default G/L number. (You should only change the A/R Control number in the (L2) screen.)

5. In the Post Date box, you can type a new date, or accept the default date. This box defaults to the system date. The posting date indicates when a posting is made.

6. When you finish entering the batch information, click OK.

7. The Select Import File dialog box automatically opens so you can select the file to import. The Files to Type box defaults to import an Excel Worksheet. Scroll to the location on your hard drive where the file to import is stored and click Open.

8. The Import Details dialog box opens, displaying information for the spreadsheet selected. This includes the Seq through Exceptions boxes. (The Seq box indicates the line from the spreadsheet.) Any exceptions appear in the Exceptions box. For more details, see In the Accounts Receivable Import Details Dialog Box.
   
   Exceptions could include the following:
   
   Leading C Removed for Credit
   Suffix Inserted Into Inv #
   User Assigned Account #
   Invoice Created
   Account # Changed From Invoiced Acct #

9. If the Account box is blank, you can choose the account for this remittance. To do so, click .

10. The Customer Selection dialog box opens. Double-click the account shown in the bottom of the dialog box, or click to open the Customer Query dialog box and choose the account.

11. Remaining issues must be corrected before the data can be imported. You can correct problems using the original spreadsheet. Then reimport the updated spreadsheet.

12. When you are ready to import the remittance data, click Import. The information appears in Notepad. You can view, print, and save to a file. If you do not save the information and reimport the same remittance data, the new data overwrites the existing data. At this point, the system posts the remittance data to the batch number you specified.