All Collections
Tali FAQ Articles
How do I process an Oracle transaction from the City of Edinburgh so I can reconcile my bank account?
How do I process an Oracle transaction from the City of Edinburgh so I can reconcile my bank account?

Process Oracle transactions from City of Edinburgh

Becky Watson avatar
Written by Becky Watson
Updated over a week ago

Pebble has been asked to give advice on how to do this. Please contact your Finance Officer at City of Edinburgh if you need any further clarification.

There are several solutions to this question. Please choose the one best suited to your school.

Solution 1

Wait until the Oracle debit is taken from your bank account before you Record Expenditure for each individual item so you can accurately reflect each debit against each account code, using Oracle or similar as the Name.

Solution 2

Wait until the Oracle debit is taken from your bank account before you Record Expenditure (total amount) and then split this across the different accounts as necessary.

Method:

  • Create a new Account to Record Expenditure to, if necessary.

  1. Create a new Account in Administration > Manage Accounts > Create New Account.

  2. Name the Account e.g. City of Edinburgh Oracle.

  3. Save the new Account.

  • Create a new Organisation Name, if necessary.

  1. Create a new Organisation Name in Administration > Manage Names > Create New Organisation.

  2. Name the Organisation e.g. Oracle Payments.

  3. Save the new Organisation.

  • Record Expenditure.

  1. Record the whole Oracle debit transaction from your Bank Statement against the new Account and Name.
    Use Direct Debit as the Type and the Date should be the date from the Bank Statement.

  2. Click Save.

  • Split Expenditure.

  1. Using the split this expenditure feature at the top of the saved transaction, split it across the different Account Codes as necessary.
    โ€‹Tip: You can use plus and minus figures to do this as appropriate.

  • With the last split expenditure clicked, confirm all the actions you have done by clicking Finished.
    โ€‹Note: Split expenditure must be clicked at least once before you click Finished.

Solution 3

Before you submit Oracle, gather together the details of the Oracle transaction so you can Record Expenditure and then split this across the different accounts as necessary.

Method:

  • Create a new Account to Record Expenditure to if necessary.

  1. Create a new Account in Administration > Manage Accounts > Create New Account.

  2. Name the Account e.g. City of Edinburgh Oracle.

  3. Save the new Account.

  • Create a new Organisation Name, if necessary.

  1. Create a new Organisation Name in Administration > Manage Names > Create New Organisation.

  2. Name the Organisation e.g. Oracle Payments.

  3. Save the new Organisation.

  • Record Expenditure.

  1. Record the whole Oracle debit from your Bank Statement against the new Account and Name.

  2. Click Save.

  • Split Expenditure.

  1. Using the split this expenditure feature at the top of the saved transaction, split it across the different Account Codes as necessary.

  2. With the last split expenditure clicked, confirm all the actions you have done by clicking Finished.
    โ€‹Note: Split expenditure must be clicked at least once before you click Finished.

If when the Oracle Debit is processed and then debited it is more or less than expected you can adjust each account by transferring the difference from the account (positive or in reverse for a negative) using Transactions > Transfer between accounts. For more information, see the Article, Transfer Between Accounts.

ย 

Did this answer your question?