Uncommon Comforts Plain comparisons of the tools you keep your people and your work in

How to link bank accounts for automatic import of transactions

Link bank accounts for automatic transaction import as a freelance designer or consultant, with steps, tool options, and common mistakes.

By Uncommon Comforts ยท

Uncommon Comforts is published by the team behind Connections, whose products are compared here alongside other tools.

Link your business account through a tool that supports your bank, sign in only through your bank's secure window, and check the first import before you rely on it.

OptionHow transactions arriveFree tier [[c:connections-ledger-pricing-plans]]
Connections Ledger [1]Linked bank account [1], or uploaded CSV or PDF statements [1]300 transactions a month [1]
Your bank's statement downloadDownloaded CSV or PDF file that you upload yourselfDepends on your bank
A spreadsheet you update by handEntries you type or paste inDepends on the spreadsheet software you use

What you need before you start

Gather the login details for each bank account and card you use for client payments and business costs. Write down each bank's name exactly as your online banking shows it, so you can find it quickly in any tool's list of supported banks.

Decide which accounts are business accounts. Many freelancers keep one account for client money and a separate one for personal spending. Mixing them makes every later step harder, so separate them now if you can.

Your bank will ask you to confirm your identity, usually with a text message or an app code, so keep your phone nearby. Download a few months of past statements in CSV or PDF format as a backup. You will need them if a direct link fails or if you want older history in the records.

Finally, note how you currently sort expenses, if you do. Your tax return will expect each expense in a set category, so knowing your existing categories makes the setup faster.

Step by step

  1. Choose the one tool that will hold your transaction records, so every later import lands in the same place.
  2. Look for the list of supported banks on the tool's sign-up page. If your bank is not on it, plan to upload statements for that account instead.
  3. Start the connection from the tool's sign-in screen and pick the option for linking a bank account.
  4. Sign in to your bank only through the secure window that the connection service opens. Never type your bank password into a chat, an email, or a form that does not come from that window.
  5. Select only the accounts you use for client payments and business costs. Leave personal accounts out so your records stay clean.
  6. Choose a start date that covers the tax year you are working on, so the history is complete.
  7. Review the first batch of imported items. Look for missing transactions, duplicates, and personal spending that should not be in the business records.
  8. Set rules for payments you see every month, such as a client's regular retainer or a software subscription, so later imports sort themselves into the right category.
  9. Upload downloaded statements for any account you could not link, in CSV or PDF format, using the same tool and the same account names.
  10. Check the records once a month and fix any wrong categories early, before they pile up at tax time.

Tools that can do it

Connections Ledger is made by the team that publishes this site. This page has no published facts about other services, so check each one's own pricing and bank link method before you choose. Three kinds of option fit this job.

Connections Ledger links a bank account through Stripe Financial Connections [1]. It also accepts bank statements in CSV or PDF format to import transaction history [1]. Transactions are sorted into IRS Schedule C categories by rule or by AI [1], and recurring charges are detected over the classified ledger [1]. Monthly budget caps with rollover are supported [1]. If you run more than one business, you can manage more than one set of books under a single login [1]. A Schedule C tax summary can be exported in one click [1]. The free tier allows 300 transactions a month [1], and Ledger is also bundled inside the paid Pass subscription tiers [1]. The same app can also be built as an Android app [1]. To begin, you sign in and link a bank account or upload a statement [1].

Your bank's own statement download is the second option. You download a CSV or PDF from your bank and upload it yourself. Which formats are offered, and how far back the history goes, depends on your bank, so check its website.

A spreadsheet you update by hand gives you full control over each line. It does not import anything automatically, so every entry comes from you.

Before you choose, confirm that your bank can be linked and count your monthly transactions against the free-tier limit of 300 [1].

Common mistakes to avoid

Mixing personal and business accounts is the most common problem. Once personal spending lands in the business records, every category total is off, and the errors are hard to find later.

Linking before you check the bank list leaves gaps. If an account cannot be connected, its transactions will be missing unless you upload its statements.

Trusting the first import without a review lets duplicates and wrong categories build up. Look at the first batch before you set rules.

Letting uncategorized items pile up makes the records harder to trust. Clear them each month rather than at tax time.

Sharing your bank password with a tool or a person who is not your bank is a serious risk. Use only the secure window that your bank or the connection service opens.

Deleting statements too early removes your backup. Keep the downloaded files until the records for that year are complete.

Assuming the import is always right is another mistake. Automatic sorting depends on the rules you approve, so spot-check it.

On the free tier, count your monthly activity against the limit of 300 transactions a month, since going past it means looking at paid options [1].

Frequently asked questions

Is Connections Ledger free for freelance designers?

The free tier allows 300 transactions a month [1]. Ledger is also bundled inside the paid Pass subscription tiers [1]. Going past the free limit means looking at the paid options, so count your monthly activity first. Whether your bank can be linked is a separate question, so check the sign-up page for supported banks before you start.

How to link a bank account for automatic transaction import?

Start from the tool's sign-in screen, choose the option for linking a bank account, and sign in through the secure window your bank shows. Select only your business accounts, pick a start date that covers the tax year, and check the first import for duplicates and personal spending. The step by step section above covers each part in order, and the same steps apply to most tools.

Can you upload bank statements instead of linking an account?

Yes. Connections Ledger accepts bank statements in CSV or PDF format to import transaction history [1]. This is useful as a backup when a direct bank link is not available, or when you want older records. Download the statements from your bank's website and upload them each month so your records stay complete.

Does Connections Ledger sort transactions for a tax return?

Transactions are sorted into IRS Schedule C categories by rule or by AI [1]. A Schedule C tax summary can be exported in one click [1]. Review the summary against your own records before you send anything to a tax preparer, because the sorting depends on the rules you set and the transactions you approve.

What happens to repeat client payments and subscriptions?

Connections Ledger detects recurring charges over the classified ledger [1]. This flags regular charges so you can review them without scanning every line. Check what it finds, since a regular charge may be a personal expense or may belong to a client project you want to track separately.

Connections Ledger's free tier allows 300 transactions a month, and Ledger is bundled inside the paid Pass subscription tiers. [1] Connections Free costs $0, and going over a limit stops the feature rather than billing you. [1]

Try Connections Ledger

Sources

  1. Connections Ledger's own description of itself (the product of this site's publisher)

Related comparisons