Watch our video walk-through:
This article focusses on reconciling your Truss Card Account by uploading the CSV file of your Truss Card Statement.
Please note, you may also reconcile the card account by connecting the account to QBO. This second option is ongoing and automatic. You can learn how here.
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 Card Account statement
Login to your Truss dashboard.
Navigate to Accounts > Card account > Statements
Click on the statement you want to reconcile and click on the 'Download as CSV' button in the top-right corner of the dashboard.
4. Reconciling a Truss Card statement in QBO
4.1 Upload your Truss Cash Account statement
Under the Bookkeeping tab, click 'Transactions'.
Open the 'Link account' dropdown to select 'Upload from file'.
Upload the previously downloaded CSV statement file (see step 2).
Select the respective account for the uploaded transactions file (e.g. 'Truss Card').
Review the formatting of your data and set the date format to 'mm/dd/yyyy'. When everything looks good, click 'Continue'.
Select all transactions you want to import from the list and click 'Continue'.
All imported transactions will then show on the 'Truss Card' account under the 'For Review' tab.
3.2 Review & categorize transactions
Review all transactions and categorize the 'Vendor' and 'Category' field. You can also select a 'Customer', if the expense is billable to a customer.
Hint: For card repayments, select 'Record as credit card payment' and create a rule to automatically match card payments with your Cash account.
Once reviewed, confirm each transaction individually or select multiple transactions at once and click 'Confirm'.
All confirmed transactions will then show under the 'Categorized' tab.
4.3 Reconcile the account
Go to 'Reconcile' under the 'Bookkeeping' tab.
Select the 'Truss Card' account from the dropdown. Enter '0.00' as your ending balance and select the ending date of the statement. Click 'Start reconciling'.
Ensure that the values equal to zero at the end to ensure it has been balanced properly. You can save this for later or click 'Finish now'. to finalize reconciliation.
