Receipts Import

The Receipts Import tool can allow users to quickly import receipts into the system. This is ideal for users who are recording cash receipts in bulk. 

Finding the (AR) Receipts Import Tool

1) Navigate to Accounting > Receipts Ledger. 

2) Go to Import Bulk Receipts to view the import page in the system. 

How to Add / Fill-in Information

The Receipts Import tool has an export file that can be used to fill out information and reupload. Additionally, users can enter the information directly into the database spreadsheet provided by cieTrade.

Export Method:

Navigate to Actions > Download Blank Template, which will export an Excel file with the standard template for this import.

Once the file is filled out, click Open Template to select the file and upload details into the columns in the system.  Make sure to select the appropriate Dept, Deposit To bank, Payment #, and Payment Date.  Reference #, and 'Use Tolerance Adjustment' are optional fields.  More information on tolerance adjustments can be found below.

Click Import to bring the detail into cieTrade as needed.

In-cieTrade Method:

Each column represents a data point on the Receipts form. Each row represents a different receipt. Add the needed information into the available and applicable fields within the spreadsheet. Once all of the information has been added, click the  Import  button to bring it into the system.

Once this template is imported into the system, these newly recorded receipts will sit on the Receipts Ledger inquiry.

Flagged Cells & Common Issues

Upon uploading the spreadsheet, you may run into a problem where a handful or more data cells are flagged, which will prevent the upload from being completed. The most common cause of a flagged cell is due to an issue with the information in the cell, or the format that it is in. After the validation check, which occurs upon clicking the Import Data button, a comment will be added to any flagged cell detailing the reason why it was flagged.

NOTE:  Details in the INVOICE NO. column MUST match an existing invoice number in cieTrade to apply the payment.  Outstanding invoices can be found by running the AR Aging Detail report.

Tolerance Adjustments

Users leveraging the 'Use Tolerance Adjustment' on this feature MUST set up a fixed or percent based tolerance amount in Settings > Accounting > Settings > Cash Receipt Import Adjustment.  The Fixed Amount option will be a flat dollar amount, whereas the % Of Invoice Amount will calculate based on the total invoice value.