--- title: Managing Bank Accounts (QBO) slug: mufg/managing-bank-accounts-qbo description: Learn how to manage your account balances and transactions by viewing them in FISPAN sync and importing them into QBO. docTags: createdAt: 2022-09-08T16:37:00.000Z --- FISPAN Sync connects your accounting system directly to your bank, providing a single view for cash management and the reporting of bank accounts. Follow this guide to learn about the Cash Management product and how to use the Reporting features to import bank accounts into QuickBooks Online. *** ## View Balances & Transactions Follow these steps to view and export your bank account Balances and Transactions using FISPAN Sync. :::::WorkflowBlock :::WorkflowBlockItem ### Navigate to Balances and Txns. From anywhere in FISPAN Sync, select **Balances and Txns.** ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/_CDkajZD3sIjVB2BkdV0h-20260530-231539.png" size="80" width="800" height="115" position="center" caption="Select Balances & Txns" darkWidth="800" darkHeight="115" showCaption="true"} ::: :::WorkflowBlockItem ### View Balances & Transactions Go to the Balances page to see your balance information, where you can filter it by Currency. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/RwidPLgxLQWH7yLmG2YrJ-20260530-231857.png" size="80" width="800" height="111" position="center" caption="View Balances" darkWidth="800" darkHeight="111" showCaption="true"} You can also use the filters to view transactions over specific timeframes, such as weekly, monthly, or a custom range. Details include previous day, intraday, and near real-time transaction information for your in-scope accounts, sourced directly from your bank. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/LLQlNRQ7Tw3eD5huge6ZA-20260530-232138.png" size="80" width="800" height="371" position="center" caption="View Transactions" darkWidth="800" darkHeight="371" showCaption="true"} You can also select a transaction to view further details, such as the description. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/ZUgfiglgvyelsQPzQhzyz-20260530-232448.png" size="64" width="800" height="355" position="center" caption="View Transaction Details" darkWidth="800" darkHeight="355" showCaption="true"} ::: ::::WorkflowBlockItem ### Export Balances Balances can be exported in CSV file format by clicking **Export**. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/XjoPJqMgBoRAmUL-o65kx-20260530-232727.png" size="30" width="800" height="687" position="center" caption="Click Export" darkWidth="800" darkHeight="687" showCaption="true"} :::hint{type="info"} **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 FISPAN Sync to your computer, follow these steps to upload them to QuickBooks Online: ::::WorkflowBlock :::WorkflowBlockItem ### Upload the File Log in to **QuickBooks Online** and click on **Accounting**, then select **Bank transactions**. In the top-right corner, click at the **dropdown arrow **right next to "Link account", and select **Upload from file**. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/tqcK4mG56LySDrHHSGJ2A-20260530-233448.png" size="80" width="2766" height="540" position="center" caption="Select Upload from File" showCaption="true"} Select the transaction file you exported from FISPAN Sync and click **Continue** in the bottom-right corner. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/zuQU5CNIAp-Eq09doxMjM-20260530-235004.png" size="80" width="2020" height="1600" position="center" caption="Import Bank Transactions" showCaption="true"} Select the **account** you want to reconcile and click **Continue**. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/ILANZokReYF-MO8MWk7xN-20260530-234823.png" size="80" width="2012" height="1048" position="center" caption="Select Account" showCaption="true"} ::: :::WorkflowBlockItem ### 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 | ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/TTi8qHfxfg4U51BreWWVG-20260530-235618.png" size="80" width="800" height="849" caption="Map the Fields" position="center" darkWidth="800" darkHeight="849" showCaption="true"} ::: :::WorkflowBlockItem ### Verify the Values and Select Transactions Use the checkboxes on the left to select which transactions you want to pull into QuickBooks Online. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/sfZdv4xRMpJDVU2L4ypG6-20260530-235848.png" size="80" width="800" height="736" caption="Select Transactions" position="center" darkWidth="800" darkHeight="736" showCaption="true"} Scroll to the bottom of the list and click **Continue**. ::: :::WorkflowBlockItem ### Finalize the Import Confirm the import by selecting **Yes**. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/cEFUJm3wc26bYI7Wyz36i-20260531-000654.png" size="66" width="948" height="438" darkWidth="800" darkHeight="257" position="center" caption="Confirm Import" showCaption="true"} After the import is complete, QuickBooks Online will show a confirmation screen. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/Kx3wQRyFVFCqhcgClY6PM-20260531-000806.png" size="80" width="800" height="226" caption="Import Completed" position="center" darkWidth="800" darkHeight="226" showCaption="true"} ::: :::: *** ## Categorize and Reconcile Transactions The imported transactions are now ready for action. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/tIz42FM1p7ks1iIxNh38X-20260531-001308.png" size="80" width="800" height="427" caption="Categorize Transactions" position="center" darkWidth="800" darkHeight="427" showCaption="true"} You must categorize these transactions to officially add them to your books. (You can refer to this video for guidance on categorization.) ::embed[]{url="https://www.youtube.com/watch?v=ysV2XucnQog&t=33s"} Over time, QuickBooks Online 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. ::embed[]{url="https://www.youtube.com/watch?v=qyGL5Duw6nk"}