Documentation

Complete guide to using TrekBudget for managing your bank accounts in Google Sheets.

Getting Started

1. Installation

Install TrekBudget from the Google Workspace Marketplace:

  1. Open Google Sheets
  2. Go to Extensions → Add-ons → Get add-ons
  3. Search for "TrekBudget"
  4. Click Install and grant necessary permissions

2. Configure GoCardless

TrekBudget uses GoCardless for secure bank connections. You'll need free API credentials:

  1. Visit GoCardless and create a developer account
  2. Get your Secret ID and Secret Key from the Bank Account Data dashboard:
    • Important: GoCardless has two separate portals - one for payments and one for bank account data
    • You sign up through the main GoCardless portal, but you need to log into the Bank Account Data portal to get your API credentials
    • Navigate to https://bankaccountdata.gocardless.com/overview/ and log in with your GoCardless credentials
    • Find your Secret ID and Secret Key in the API credentials section
  3. In Google Sheets, go to Extensions → TrekBudget → Settings
  4. Enter your GoCardless credentials
  5. Click Save

Managing Accounts

Adding a Bank Account

  1. Go to Extensions → TrekBudget → Manage Accounts
  2. Click "Add Account"
  3. Select your bank from the list
  4. Complete the OAuth authorization flow with your bank
  5. Your account will appear in the list

Renewing Expired Accounts

Bank connections expire after 90-180 days (varies by institution). To renew:

  1. Go to Manage Accounts
  2. Click "Renew" next to the expired account
  3. Complete the OAuth flow again
  4. Your custom account names and settings will be preserved

Deleting an Account

  1. Go to Manage Accounts
  2. Click "Delete" next to the account
  3. Confirm deletion
  4. Note: This removes the connection but keeps historical data in your sheets

Importing Transactions

Manual Import

  1. Go to Extensions → TrekBudget → Import Transactions
  2. Select date range
  3. Select accounts to import
  4. Click "Import"
  5. Transactions will be written to the TB_Transactions sheet

Automatic Daily Fetching

Enable auto-fetch to automatically import yesterday's transactions daily at 2 AM:

  1. Go to Settings
  2. Toggle "Enable Auto-Fetch" to ON
  3. Click Save

Understanding the Data

The TB_Transactions sheet contains these columns:

  • Date: Transaction date
  • Description: Transaction description
  • Amount: Transaction amount (negative for debits, positive for credits)
  • Currency: Currency code (EUR, USD, etc.)
  • Account: Account name
  • Transaction ID: Unique identifier
  • Booking Date: Date when transaction was booked

Balance Tracking

Balances are automatically fetched when you import transactions. They're stored in the TB_Balances sheet:

  • Date: Balance snapshot date
  • Account: Account name
  • Balance: Current balance
  • Currency: Currency code
  • Type: Balance type (interim, closing, etc.)

Troubleshooting

Invalid GoCardless Credentials

If you see this error, check that your Secret ID and Secret Key are correct in Settings.

Account Connection Failed

Some banks may have specific requirements. Try these steps:

  • Ensure you're using the correct login credentials
  • Check if your bank is supported by GoCardless
  • Try the connection again after a few minutes

No Transactions Imported

  • Check the date range - some banks limit historical data
  • Verify the account connection is active
  • Ensure there were transactions in the selected period

Auto-Fetch Not Working

  • Verify auto-fetch is enabled in Settings
  • Check that your GoCardless credentials are valid
  • Look for error logs in Extensions → TrekBudget → View Logs

Licensing

Free Tier

Connect 1 requisition with all features included. What's a requisition?

Pro Tier (€19/year)

Connect up to 20 requisitions. To upgrade:

  1. Go to Extensions → TrekBudget → Upgrade to Pro
  2. Complete purchase
  3. Enter your license key
  4. Click Activate

Need Help?

Contact support at support@trekbudget.com