Castaway's Integration is a huge time saver that allows you to quickly build your Chart of Accounts and set up your file so you can draw months of Actuals with just a few clicks of the mouse. A huge part of this process is the mapping process which allows you to allocate your general ledger accounts to Castaway's Chart of Accounts. The program offers you flexibility in changing your mapping i.e. where the values are to be drawn to in Castaway, as often as you'd like.
There may be instances where you realize that your accounts are out of balance because Castaway is pulling the Actuals in two places - the previously mapped account and the new mapped account. This is because Castaway will still retain the values in the old account if the old account is left unmapped.
To resolve this, follow the steps down below:
- Go to Forecast > Opening & Actuals
- Clear out all the Balance Sheet values starting from the month where the Out of Balance occurs because of the remapped account. This can be easily achieved by highlighting the relevant cells and then entering the Delete key on your keyboard.
- Do the same for your Profit and Loss values
- Go to External Sources and reimport your Actuals via Integrations using the mapping file with the new mapping
- Review your Actuals to confirm that the values are now balanced and are imported into the new accounts
A good practice to implement as you reimport your Actuals via Integrations is to first clear the Profit and Loss and Balance Sheet values in the month you're reimporting to ensure that the reimported values are correct.
If your Balance Sheet is still Out of Balance despite following the guide above, please reach out to our Support Team.