Support
Transactions
Importing Transactions

Importing Transactions

Last updated:

September 10, 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.

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.

Why It Is Essential To Get a Business License

Why It Is Essential To Get a Business License

Small business owners want to ensure that their operations are legal from the beginning. But, it is possible that you may not know what legal obligations you have. This article will explain how to obtain a U.S. business license and why it is important.

Does the IRS Accept Digital Receipt Scans for Taxes?

Does the IRS Accept Digital Receipt Scans for Taxes?

If you are hoping to simplify this procedure by scanning your receipts, you may be wondering whether or not the Internal Revenue Service would accept your scanned receipts. Do scans of receipts have the same legal weight as the original paper versions when it comes to supporting tax write-offs?

Photo by Jernej Furman - Paypal Logo On Screen Under Magnifying Glass

PayPal 1099-K: A Guide for Freelancers and Sellers

If you generate income through your website, or managing multiple clients as a freelancer, chances are you'll receive payments via PayPal. In this guide, we'll explain who gets a PayPal 1099-K, what to do with it, and how to file your self-employment taxes.

How To Start a Successful Business By Using Direct Sales

How To Start a Successful Business By Using Direct Sales

If a business doesn’t have steady revenue, it has little chance of success. In direct selling, it is critical to determine which strategies attract and keep consumers. These are five most effective direct sales strategies and how direct sales can make your small business or brand successful and profitable.

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.