Overview
The Castaway integration with QuickBooks Online is a one-way integration from QuickBooks Online to Castaway, giving Castaway access to your QuickBooks chart of accounts and trial balance reports. Connecting via an integration source is the recommended approach for building a Castaway file - it is the fastest way to build your chart of accounts and ensures your model is grounded in real financial data from the outset.
Once integrated, you can:
- Build a new Castaway Project from your QuickBooks file including mapping
- Map the QuickBooks chart of accounts to an existing Castaway Project
- Import opening balances and actuals data for one or multiple months
Who can Connect to QuickBooks Online?
Any Castaway user can connect a QuickBooks Online file as an integration source with the exception of users with Read Only access.
Connecting to your QuickBooks Online File
- Go to Forecast > External Sources and click the QuickBooks logo. You can also access this when creating a new Project by clicking the QuickBooks logo from the integration options screen.
- You will be prompted to log in to QuickBooks Online if you have not already done so. Your Project Details will be pre-filled with information from your QuickBooks file and can be adjusted as needed.
- Select the QuickBooks company you wish to connect and click Next.
- Castaway will ask for confirmation to connect with your data - click Connect.
- Select your file and click Import.
The number of months loaded defaults to 24 months from today. If you need to load more or fewer months, adjust this from the bottom left of the confirmation screen.
For further guidance refer to: Importing More than 24 Months via Integrations
Updating your QuickBooks Online Data
Once your file is connected, you can refresh your QuickBooks Online data at any time to pull in the latest values. To refresh, go to Forecast > External Sources and click Refresh Data. This will bring the latest values into the mapping screen for you to review before importing.
If you have made changes to your mapping and need to clear your actuals data before reimporting, refer to: Clearing Actuals Data
Next Steps - Mapping your QuickBooks Accounts to Castaway
Once your file is connected, click Map to begin mapping your QuickBooks accounts to the Castaway chart of accounts. Click and drag accounts across to build your chart of accounts.
For comprehensive mapping guidance, refer to: Mapping your Chart of Accounts (CoA)
For an overview of the build process, refer to: Process: Building your Forecast