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) Connect your Truss Account in QuickBooks Online
First, you need to add Truss as a linked account within your QuickBooks dashboard to enable the automated bank feed.
Log in to your QuickBooks Online account.
In the search bar, type "Link Accounts".
Search for "Truss" in the search bar and select it from the results.
Click Continue to be redirected to the Truss secure login portal.
2) Authenticate your Truss Account
You will be redirected to a secure login page to verify your Truss credentials.
Enter your Truss login credentials (email and password).
Follow any multi-factor authentication (MFA) prompts if required.
Once authenticated, you will be prompted to authorize QuickBooks to access your Truss data. Click Allow or Connect.
3. 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
4. Reconcile a Truss Cash statement in QBO
4.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.
4.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.
