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.

‍

A Simple Guide to Cancelling PayPal Transactions

Whether you accidentally paid the wrong person or the deal fell through, here's a guide on how to cancel a PayPal transaction, and what to do if cancellation isn't possible.

The Importance of Keeping Track of Your Digital Receipts

Both small businesses and individuals are legally required to retain receipts and invoices for a minimum of seven years. Typically, this meant stacks of papers on your desk or in filing cabinets, which took up a lot of space but served little another purpose than to sit there and store documents.

Strategies for Saving for a Vacation

Are you dreaming of a well-deserved vacation but struggling to save up for it? Saving money can be a challenge, especially when it comes to funding your dream getaway. However, with the right strategies and a little discipline, you can make your vacation dreams a reality.

Understanding PayPal Transfer Limits

PayPal's transfer limits are in place to protect users and their PayPal balances, and they serve as a security measure to prevent unauthorized or erroneous transfers. Learn more about PayPal limits in this article.