How to Load Opening Balances for Commercial Debtor
Important! This guide is only required as part of the initial setup of TASS in your organisation.
As part of the initial setup of TASS you will need to transition a full list of Commercial Debtor balances from your previous system to TASS. The balances should be from the end of the period prior to the day before you are changing to TASS. The total of this list must be reconciled with the Commercial Debtors Control Account in the General Ledger as at this date.
Item | Process | Details |
|
---|---|---|---|
1 | Open the current period | Go to Finance > General Ledger > Setup Information > Years and Periods. Set the period immediately before the TASS changeover date to 'Open'.
Following the process above, ensure the box in the 'Com' column is unticked for all other periods in that same year and the following year. This sets those periods to 'Closed'. |
|
2 | Transfer the balance of the Commercial Debtors Control Account to the General Suspense Account | Go to Finance > General Ledger > Account & Journal Info > Journal Upload in the TASS Help Centre and follow the instructions to prepare the new Journal Upload File. Go to Finance > General Ledger > Account & Journal Info > Journal Upload in TASS.web.
The journal should be: General Suspense Account xxxxx.......xxxxx Dr Commercial Debtors Control Account xxxxx......xxxxx Cr |
|
3 | Prepare and upload the Commercial Debtors Opening Balances File | Go to Finance > Commercial Debtors > Customer Transactions > Invoice/Credit Upload in the TASS Help Centre and use the instructions to to prepare Commercial Debtors Opening Balances Upload File. Important! The 'Transaction Date' will be the day before the TASS changeover. The 'GL Account' must be the 'General Suspense Account used in step above. The 'Tax Code' should be 'NOT'. Go to Finance > Commercial Debtors > Customer Transactions > Invoice/Credit Upload in TASS.web.
Important! Go to Finance > Commercial Debtors > Customer Transactions > Invoices and run an Invoice List for the date of the upload file and check that all commercial balances agree with the list from your previous system before proceeding. |
|
4 | Post Entries | Go to Finance > Commercial Debtors > Period End > Post Period Activity.
|
|
5 | Check the Balances | Go to Finance > Commercial Debtors > Listings & Reports > Debtors Trial Balance.
Important! Choose the Year and Period that includes the day before the TASS changeover.
Check that all the balances and the report total reflects the list from your previous system before proceeding. |
|
6 | Close the Period | Finance > General Ledger > Setup Information > Years and Periods.
|
|