Skip to main content

Reconciling your Truss Cash Account in Quickbooks Online

Reconcile your Truss Cash Account by uploading your account statements to Quickbooks Online.

Updated over 3 weeks ago

Before you can reconcile your Truss Cash Account in Quickbooks Online, you need to add a new Chart of Accounts in QBO for Truss.


1. Add a new Chart of Accounts for Truss in QBO.

  • Under the Bookkeeping tab, click 'Chart of accounts'.

  • Click 'New' to add a new account.

  • Fill in the fields with the following settings:

    • Account Type: Bank

    • Name: Truss

    • Detail Type: Checking

  • Select the date at which the transactions start.

  • Set the opening balance as zero (or use the starting balance if applicable).


2. Download your Truss Cash Account statement.

  • Login to your Truss account

  • Navigate to Accounts > Cash under Truss Accounts

  • Click the statements tab

  • Click the statement you wish to reconcile from the list

  • Click the 'Export as CSV' button in the top right corner


3. Reconcile a Truss Cash statement in QBO

3.1 Import and categorize your transactions

  • Under the Bookkeeping tab, click 'Transactions'.

  • Open the 'Link account' dropdown to select 'Upload from file.'

  • Upload the previously downloaded CSV account statement file

  • Select the respective account for the uploaded statement file (e.g. 'Truss').

  • Review the formatting of your data and set the date format to 'mm/dd/yyyy'.

  • Select all transactions you wish to import from the list and click 'Continue'.

  • All imported transactions will show on the 'Truss' account under the 'For review' tab.

  • Review the details of the transactions and make adjustments as needed.

    • Hint: If there are card payments in your statement, set a rule to 'Record as credit card payment' to automatically match them with your card statement.

  • Once reviewed, confirm each transaction individually or select multiple payments at once and click 'Confirm'. Your transactions will then show under the 'Categorized' tab.

3.2 Reconcile imported transactions

  • Go to 'Reconcile' from the left-hand menu under 'Bookkeeping'.

  • Select the 'Truss' account from the dropdown. Enter the ending balance of your statement and select the ending date.

  • Review the transactions and ensure that the values equal the ending balance to ensure it has been balanced properly. Match up incoming and outgoing payments if needed.

  • When everything looks good, click 'Finish now' to finalize the reconciliation.

Did this answer your question?