Support
Transactions
Importing Transactions

Importing Transactions

Last updated:

November 6, 2023

It is important that you upload accurate information for the import process to be successful. Please be sure to double-check your upload file before upload. There's no bulk deleting of transactions in Balance Pro. If you upload 100 transactions and they are wrong, you'll have to delete those one-by-one manually.

Please note: After you have imported your transactions, navigate to the account and verify the import. If you do not see any transactions imported it means your upload CSV file is incorrect.

Upload Fields and Requirements (Limit 1,000 items)

Field Name

Type

Example

More Details

Name (Required)

Text

Costco

Short name of the transaction.

Date (Required)

Date

11/14/2022 3:31:00 PM

The time is optional, but recommended.

Amount (Required)

Decimal

-10.15

Can be a positive or negative number. For negative numbers, include a hyphen (-) in front of the number. The number should have 2 decimal places.

Type (Required)

Text

Deposit (+)

Must be one of the following: Credit (+), Debit (-), Deposit (+), Expense (-), Income (+), Incoming Transfer (+), Outgoing Transfer (-), Payment (-), Purchase (-), Withdrawal (-).

Cleared (Required)

Yes/No

yes

Must be either "yes" or "no" (without quotes)

Category (Required)

Text

Groceries

Must be one of the following categories:
Business, Clothing, Debt, Education, Entertainment, Gifts & Donations, Groceries, Health & Fitness, Hobbies, Housing, Income, Insurance, Kids, Loan, Medical, Office & Business, Other, Personal Care, Pets, Phone & Internet, Professional Services, Restaurants, Savings & Investments, Shopping, Transfer, Transportation, Travel, Utilities, Vacation

Color Tag (Required)

Text

Red

Must be one of the following: None, Blue, Green, Orange, Purple, Red, Yellow.

Notes (Optional)

Text

This is a note.

Short text accompanying the transaction.

Receipt Photo (Optional)

URL

https://website.com/link-to-image.jpg

Must be an HTTPS link to a jpg or png.

Buying vs Renting a Home

Buying vs Renting a Home

Taking the time to assess your financial situation and consider the options is one of the most important steps when deciding whether renting or buying a home is right for you.

Can a Gym Membership Be a Tax Write-Off?

Can a Gym Membership Be a Tax Write-Off?

Are you wondering if you can deduct your gym membership as a business expense on your taxes? Read this article to find out.

Finding a House Within Your Budget

Finding a House Within Your Budget

We explore various strategies and financial considerations to help you find a home that not only suits your needs but also aligns with your financial capabilities.

Combining the Standard Deduction and Business Expense Deductions: Can You Do Both?

Combining the Standard Deduction and Business Expense Deductions: Can You Do Both?

It's no surprise that self-employed individuals strive to minimize their taxable income as much as possible. A frequently asked question is whether they can claim the standard deduction while still deducting business expenses.

By clicking “Accept”, you agree to the storing of cookies on your device for analytics and marketing purposes. View our Privacy Policy for more information.