Reconciliation files' location

...

1. Connect to Zuora

   1. Tourisoft Sàrl: https://www.zuora.com/webapp

   2. Hotel-Spider Germany Gmbh: https://eu.zuora.com/webapp/

2. There are multiple ways to find the accounts/invoices corresponding to the payments received:

   1. Invoice number (if available)

   2. Account Number (if available)

   3. Name of Client (if available)

   4. If none of the above are available , please try cross referencing in the“debiteurs” sheet located in the excel file

   5. As a last resort, try cross referencing the data in Zoho, Zendesk, Google, etc.

   6. If really no luck, await the return of Trevor 😊

IMPORTANT: A payment must ALWAYS be linked to an account in Zuora, whether there is an invoice or not! If you cannot find the account at all, please mark it in the excel sheet and contact Trevor

Reconciliate payment through the account number/ name:

...

1. Payment date (column L)

2. Payment Method: ALWAYS select Wire transfer

3. Payment total: Check payment total

4. Reference ID: Enter reference ID (column P)

5. Comment: Enter Bank account number into “comment” (cell 1O)

6. Invoice(s) associated to the Payment:

   1. Select the invoice(s) associated to the payment

   2. If there are no invoices, the payment will automatically go to the credit balance

7. Click on “create payment”

8. Mark the payment as processed in the excel sheet by selecting the corresponding category under “transaction category” in column V

9. If there is a doubt and/ or issue, leave column V blank, highlight the transaction and leave a comment in column W

...