Use the Spreadsheet Import wizard to import client transactions from a spreadsheet file using .XLS or .XLSX file format. The source of the transactions in the spreadsheet could be data downloaded from a bank statement or other accounting applications such as Point of Sale applications, ADP payroll, or BAI2 or OFX files.
Special informationThe application supports the import of several transaction types, including payroll checks. To import after-the-fact (handwritten) payroll checks, use the Enter Batch Handwritten Payroll Checks screen. To import unprinted checks, the transaction status must be either "Handwritten" or "Unprinted".
Transaction type Acceptable spreadsheet values Accounts Payable Check, AP Check, AP Chk, AP C If the AP service is not enabled, the application displays an error in the Transaction Type field. AP payment Accounts Payable Payment, AP Payment, AP Pmt, AP Pay, AP P If the AP service is not enabled, the application displays an error in the Transaction Type field. Check, Chk, C This type will be imported as a Deposit. Debit, DR, DB This type will be imported as a Payment. Deposit, Dep, D Journal entry Journal Entry, JE If you are licensed for only Accounting CS Payroll, the application will not import journal entries. Payment, Pmt, Pay, P Withdrawal Withdrawal This type will be imported as a Payment.During the import, if the application encounters a blank general ledger account or if a column has not been mapped for the general ledger account, the application fills in the general ledger accounts automatically .
Checks or payments If the vendor record includes a single distribution, the application uses that account.If the vendor record includes multiple distributions and the number of distributions in the imported transaction matches the number of distributions in the vendor record, the application assigns the distributions to the distributions in the same order as in the vendor record.
If number of distributions in the imported transaction does not match the number of distributions in the vendor record, or if no vendor record is found, the application uses the Undistributed general ledger account specified in the Accounting Information tab of the client record.
AP checks or AP paymentsIf an Accounts Payable general ledger account is specified in the vendor record, the application uses that account. If an Accounts Payable general ledger account is not specified in the vendor record but an Accounts Payable general ledger account is specified in the client record, the application uses that account. If no vendor record is found, the application uses the Undistributed general ledger account specified in the Accounting Information tab of the client record.
All other transaction typesThe application replaces all blank general ledger accounts with the Undistributed general ledger account specified in the Accounting Information tab of the client record.
The application sets the posting period based on the transaction date.If a transaction is dated in the current fiscal year based on the current posting period, the application posts the transaction to the period for which it is dated.
If a transaction is dated in any future fiscal year for which an associated posting period exists, the application posts the transaction to the future period for which it is dated.
If a transaction is dated with a date in a prior fiscal year or with a date in a closed period in the current fiscal year, the application posts the transaction to the current period, displays a warning message, and lists the transaction in the diagnostic report.
If a transaction is dated with a future date for which there is no appropriate posting period, the application displays a critical error.