Managing Balances & Transactions (QBO)

step 1 navigate to balances & txns from anywhere in fispan sync, select balances & txns step 2 view balances & transactions balance information is visible from the balances page 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 a transactions to view further details such as description balances can also be exported in csv file format by clicking export 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