How to create a positive pay issue using Excel?
For certain business accounting software packages, you can export records of issued checks to an ASCII or text file. By using Microsoft Excel, you can reformat these records into a PC file format that can be transmitted via modem to Bank of America. 1. Follow instructions for creating a file of issued checks from your accounting software package. Files will most likely be saved as a print or formatted text file (.PRN filename extension), text file (.TXT filename extension), or ASCII file (.ASC filename extension). 2. Open Excel and from the File, Open command, select the file. Remember to change the file type in the Open command window to “All Files” so that you can access your check issue file that may be saved with a .PRN, .TXT or .ASC filename extension. 3. When you open these types of files, a Text Import Wizard window will open to guide you through the import process. 3A. In the Import window step 1, select Fixed Width and click on Next. 3B. In the Import window step 2, follow the
