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.

How Do I Find My Uber Receipt?

How Do I Find My Uber Receipt?

Retrieving Uber receipts may not be immediately apparent to all users. In this blog post, we will guide you through the step-by-step process of retrieving your Uber receipts using the Uber app and website

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.

Budgeting for Beginners

Budgeting for Beginners

Budgeting can help you achieve your financial goals, whether you want to save money for a down payment on a house, pay off debt, or simply have more financial security.

The Top Websites to Sell Your Designs & Artwork

The Top Websites to Sell Your Designs & Artwork

In this blog, we'll explore some of the best websites for selling artwork online, providing artists with an easy and convenient way to sell their creations and earn money directly.

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.