Receiving Cash Receipts with a Spreadsheet Upload

This article outlines how to receive money via an excel upload sheet directly in cieTrade.net.  This is the fastest method if you have a customer remittance statement with the payment details that you can copy and paste from directly.    

Before you can receive the funds, you will need:

-   The invoice or group invoice number

-   The amount to be paid against each invoice

1. Go to the Receipts tab on the left-hand menu

2. Click Tasks > Import Bulk Receipts

3. Enter Deposit to Bank account, the payment number and the payment date.   You can also select whether you wish to apply a tolerance adjustment to each spreadsheet line item. 

a. The tolerance adjustment amount can be entered in Settings > Preferences, and can be a fixed amount or percentage. 

You can then either manually type in the data, or copy and paste from an excel spreadsheet.

NOTE: to copy and paste use Ctrl C and Ctrl V.

NOTE: if no discounts are taken, you will need to record 0 in each discount box. 

4. Once the data is entered, you can then click Post.  This will create one new Cash Receipt batch for each different customer, however the total amount will post to your accounting system as one deposit amount, referencing all AR batch numbers.  

5. If there are any errors preventing the posting of the cash receipt, a message box will show on the cell(s) with the issue(s).

Note: the Payment Amt field will not allow currency symbols

6. You can access the detail of the batches posted from the Receipts Ledger.

If you have additional questions, please contact the Support Team via email to support@cietrade.net.