Importing Transactions - Balance Pro Support



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.

‍

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.

Achieving Financial Independence and Financial Wellness

Financial independence is something that we all strive for, however, it can be hard to get there. As with any kind of successful endeavor, achieving financial independence requires focus and dedication.

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

Strategies For Managing And Reducing Debt

Are you struggling with debt? Is it getting harder to pay off bills each week or month and you're feeling overwhelmed? You are not alone — debt can be a difficult challenge to face, but there is hope. There are plenty of strategies for managing and reducing your existing debt over time, so in this blog post, we'll disc