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.
