Reconciling Payments in Sage 300 CRE

1. Retrieve the current deposit report from the Payment Portal

2. In Sage 300 CRE, go to Accounts Receivable → A/R Transactions → Receipt Entry

3. Select an existing receipt batch, or create a new one

4. If desired, enter a description into the ‘Entry Description’ field

5. Select ‘Receipt’ as the transaction type

6. Enter the date of the receipt

7. Enter the following information from the first row of the deposit report CSV file:

• Customer Number: Find the customer number that corresponds to the ‘customer_company’ column
• Payment Code: Select the appropriate payment code
• Check/Receipt Number: If desired, enter the value of the ‘transaction_id’ column
• Receipt Amount: Enter the value of the ‘total’ column

8. Apply the receipt

9. Click ‘Add’

10. Use ‘Auto Apply’ to automatically apply the receipt to the customer’s outstanding invoices, or manually apply each payment.

11. Click ‘Save’ to apply the receipt.

12. Repeat steps 3-8 for each subsequent line on the deposit report.

Note: Negative deposit and deposit item amounts cannot be entered.

Entering Invoice Cash Receipts

1. Retrieve the current deposit report from the Payment Portal

2. In Accounts Receivable

3. Select Tasks, Enter Cash Receipts.

4. Select the entry view you want to use.

5. In the Deposit Information window, enter the deposit information and click OK.

6. In the Deposit Items window, select the deposit item type and enter the customer, amount, and other deposit item information.

7. In the Cash Receipts Selection window, highlight the open invoice(s) for this customer that you want to apply the cash receipt toward.

Note: You may need to deselect any invoice(s) automatically highlighted.

8. If you are applying the cash receipt to the entire invoice, click OK to exit the Cash Receipts Selection window to return to the Deposit Items window and skip to step 11.

9. To apply the deposit to individual invoice distributions (instead of to the whole invoice, need to pay the tax first) then highlight the invoice and click Cash Receipts.

10. In the Cash Receipts window, click Distributions.

11. In the Distributions window, enter amounts to apply to each invoice distribution listed.

12. When you are finished, click Finish to return to the Cash Receipts window.

13. Click Save Line, Finish Cash Receipts to return to the Deposit Items window.

14. In the Deposit Items window, enter any remaining deposit items for this session. You can view the remaining number of items or amount (entered in the Deposit Information window) at the bottom of this window.

15. If you are finished entering deposit items, click Finish to exit Enter Cash Receipts

Note: Negative deposit and deposit item amounts cannot be entered.