Managing Balances & Transactions (QBO)

step 1 navigate to balances & transactions on the dashboard, select accounts & transactions step 2 information reporting balance information is visible from the accounts & transactions tab, and filterable on the basis of currency information for your accounts in scope are shown for previous day and intraday balances, along with near real time transaction information directly from your bank you can also select more to view further details about transactions, including description and bai code balances can also be exported in csv file format by clicking export please note that the export will take into account the filters you would have set if you are exporting transactions for reconciliation purposes, make sure you have selected the right time frame you would like to process, in order to avoid double entries in your accounting software note if the file does not download, make sure your pop up blocker is disabled step 3 import the transactions into quickbooks online now that the transactions have been saved on your computer, you can upload them to your quickbooks to do so, log in to your quickbooks online and click on the banking tab to import your transaction into quickbooks online, select the upload from file option in the drop down menu on the top right corner of the screen select the file you exported from the companion app and select on continue in the bottom right corner select the account you want to reconcile and select continue map your bank statement with the quickbooks online fields (auto populated except the “amount” column) the file you will import has only one column for debit and credit the fields should be populated as the following for step 1 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 date column 1 date description column 2 description amount column 3 amount select the checkmark next to the date field to import all transactions scroll down to the bottom of the transactions list and select continue confirm the import by selecting yes after the import has been completed, quickbooks online will show you a confirmation screen you have now to categorize the transactions to add them in quickbooks you can follow the steps highlighted in this video overtime, quickbooks will recognize the transactions from the same vendors and will automatically categorize them for you you can also create custom rules to automate your workflow within the “rules” tab if you are looking for additional assistance with how to reconcile your accounts, this video will outline some best practices