Managing Balances & Transactions (QBO)

the {{companionapp}} connects your accounting system directly to your bank, providing a single view for the cash management and reporting of balances and transactions follow this guide to learn about the cash management product and how to use the reporting features to import balances and transactions into quickbooks online view balances and transactions follow these steps to view and export your bank account balances and transactions using the {{companionapp}} navigate to accounts and transactions on the dashboard, select accounts & transactions view accounts and transactions go to the accounts and transactions page to see your balance information, where you can also filter it by currency information for your accounts in scope is shown for the previous day, intraday, and near real time transaction information for your in scope accounts, sourced directly from your bank you can also select more to view further details about transactions, including description and bai code export balances balances can also be exported in csv file format by clicking export the export will take into account the filters you have set if you are exporting transactions for reconciliation purposes, ensure that you have selected the correct time frame you would like to process to avoid double entries in your accounting software note if the file does not download, make sure your pop up blocker is disabled import transactions into quickbooks online once you have saved your transactions from the {{companionapp}} to your computer, follow these steps to upload them to quickbooks online upload the file log in to quickbooks online and click on the banking tab in the top right corner, select the dropdown menu and choose upload from file select the transaction file you exported from {{fispansync}} and click continue in the bottom right corner select the account you want to reconcile and click continue map the data map the fields from your imported file to the corresponding quickbooks online fields for step 1, you will need to add the format settings for the data since your file uses a single column for both debit and credit amounts, use the following settings setting selection is the first row in your file a header? yes how many columns show amounts? one column what's the date format used in your file? mm/dd/yyyy for step 2, you will need to map the quickbooks fields to your file's specific columns quickbooks field your file column date column 1 date description column 2 description amount column 3 amount confirm and complete the import select the checkmark next to the date field to include all transactions scroll to the bottom of the list and click continue confirm the import by selecting yes after the import is complete, quickbooks online will show a confirmation screen categorize and reconcile transactions the imported transactions are now ready for action you must categorize these transactions to officially add them to your books (you can refer to this video for guidance on categorization ) over time, quickbooks will recognize and automatically categorize transactions from the same vendors for more control, you can create custom automation rules within the rules tab if you are looking for additional assistance with how to reconcile your accounts, this video will outline some best practices