How To: Reconcile Global-E Payments via Import

By creating a Global-E Bank Account in Khaos Control and downloading your Global-E transactions as a .csv file, reconciling your Global-E transactions can be done quickly and easily.

Performing the Global-E Reconciliation

1. Import the Global-E file into Excel.
2. Save the file as a .csv file, it is then ready to be imported into Khaos Control.
3. Open the [ Accounts | Bank Accounts ] tab.
4. Select the Global-E bank account from the 'Bank Account' drop-down.
5. Click on the 'Go' button.
6. Press Alt+E or click to enter edit mode.
7. Display the drop-down 'Other Actions' menu either by pressing F9 or clicking the down arrow immediately to the right of the green circle with a white cross icon at the top of the button bar.
8. Select Import then Match Global-E CSV Payments...
9. Select the import file, the Match Global-E CSV Payments Dialog appears.
10. The system will process each line in the CSV and match on the GE Order Number which Khaos Control stores as the Ass. Ref. field within the bank account grid. If this matches along with the date and the amount, the system will tick the Recon checkbox.
11. The order number in the .csv file is expected to exactly match the Ass.ref.
12. Press Ctrl+S or click to save.
13. Finish the bank reconciliation as normal, see How To: Perform a Bank Account Reconciliation.
    
    

After Reconciliation

After you have reconciled you may wish to:

1. Journal any fees charged by Global-E, this can be done is a number of ways, for example:
   1. If you need an invoice:
      1. Raise the invoice against your Global-E supplier, see How To: Enter a single line SP Ledger entry using the Global-E Fees nominal.
      2. Pay the supplier from the Global-E bank account, this should reduce the balance of the Global-E account.
   2. If you don't require an invoice post a journal between the Global-E Fees nominal and the Global-E Bank account, see How To: Journal between Nominal Accounts.
2. The remaining balance should match the final value transferred by Global-E into your main account and this is the amount you need to journal from the Global-E account to your current account; your Global-E bank account balance should then be cleared for that date range.

Notes

A dialog will appear after the reconciliation if any items in the file have been skipped. Typical reasons for items being skipped are:

1. Order not found in the banked items list (the order number in the .csv file does not match the one in the banked items list)
2. The item has either already been reconciled or the dates do not match.
3. The item amount does not match.

See Also

• Accounts overview