Tip: If Force Zero Proof in GL Settings is set to By debit/credit or By [Prefix A, B or C]:

• The total debits and credits are checked to ensure that they are in proof.
• If a file is out of proof, all records are copied from the import file and written to the rejected records file.
• An Out-of-Balance message prints on the first page of the import journal, specifying the total debits/credits, and the difference.
• An out-of-balance situation results if the original import file is out of proof or if the file is forced out of balance by a transaction record that rejects during the verification process.
• If the file is forced out of balance due to rejected records, the second page of the journal lists the transactions that rejected, along with their corresponding error messages. The line numbers on the journal correspond to the records in the rejected records file.

If Force Zero Proof is set to No when importing, see article 99452 GL Import Transactions reject file contains a transaction that successfully imported

Note if you create import files in Excel:

• Save Excel files as .txt files to import into General Ledger. Make sure the encoding type is ANSI.
• Import treats positive amounts in the credit field as credits, so keeping the negative sign attached to the credit would result in a debit (e.g., a negative credit) amount being imported.
• If you get an error about non-printable characters, save the Excel file as a .csv file first, then rename to .txt.  NOTE: The CSV file must be the CSV (Comma Delimited) type, not the CSV UTF-8 type. 
• If you're getting error / rejection: unknown record type identifier, and review of the file shows lines of commas; the print area as defined is too large and needs to be resized to fit the data. In Excel, click drag upper left to lower right of the area to include, from the Page Layout menu tab, select Print Area, Set Print Area.
• The amounts should be formatted as numbers without commas.

1. In General Ledger, select Tools, Import Transactions.
2. If a batch selection window appears, complete it as usual.
3. In the Import file field, click [...] to browse to and select your import file.
    NOTE: To select a .CSV file, select All Files from the Files of type drop-down list, and the CSV file must be the CSV (Comma Delimited) type, not the CSV UTF-8 type  
4. In the Rejected records file field, click [...] to browse to the location to save your reject file and enter a file name. This name should be different from the name of the file your are importing.
5. Make printer and page adjustments as needed, and click Start.
6. Review the Import Transactions journal:
   • If errors exist, correct them in the rejected records file. See the Help topic Correcting errors when importing transactions (Help, Help Topics in General Ledger) for more information. You can also search the Sage Knowledgebase for the rejection error.
   • Correct any errors and repeat steps 1 through 6 to import the previously rejected entries. Be sure to select the corrected rejected records file as the import file when importing those entries, not the original import source file.
7. Post the entries with Tasks, Post Entries.

Refer to the General Ledger Help Topic "About importing transactions" for further information.