All Collections
User guides
Reconciling your Truss Cash Account in Quickbooks Online
Reconciling your Truss Cash Account in Quickbooks Online

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

Updated over a week 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 Account > Statements

  • Click the statement you wish to reconcile from the list

  • Click the 'Download 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?