Keeping track of expenses can be a bit of a headache, especially when some of your spending happens outside of your usual financial management software. Luckily, Uome, the super-app for sorting out your money matters, lets you import expenses using a CSV file. This means you can have all your financial info in one place, hassle-free. In this easy-to-follow guide, we’ll show you how to import your expenses into the Uome app.
Step 1 – Get your data ready
Before you can start importing expenses, you’ll need to make sure your transaction data is all set. Here’s what you need to do:
- Export your transaction data from where it’s stored, like your bank or financial institution
- Organise this data into a CSV (Comma-Separated Values) file with these columns:
- Date, Supplier, Description, Category, Amount, VAT, Currency, Notes
- Categorise your expenses using the list below, if this isn’t declared ‘Not specified’ will be set
- Advertising and marketing
- Employee benefits
- Furniture, equipment, and machinery
- Interest payments and bank fees
- Licenses and permits
- Membership fees
- Office supplies
- Other expenses
- Professional fees and business services
- Rent or mortgage
- Shipping and postage
- Training and education
- Travel expenses
- Vehicle expenses
- Website and software
Having these categories will help you keep your expenses well-organised and make it easier to track your financial transactions in Uome.
To make sure you’re on the right track, download the CSV template to understand how the data should be laid out.
Step 2 – Must-have data
To import expenses into Uome, you’ll need to include mandatory columns with data in your CSV file. These columns are super important for keeping your records straight and for when it’s time to do your taxes. Make sure your CSV file has these columns with the relevant data:
- Date: The date when you made the transaction (in DD/MM/YYYY format)
- Amount: The amount of money spent
- Description: A brief description of the expense
Step 3: Filling in missing supplier info
Not all banks and providers give you the name of the supplier in their transaction details. Don’t worry; Uome has a clever solution. If the “Supplier” field in your CSV file is empty, Uome will use the description field to fill it in automatically.
Step 4 – Uploading your CSV file
Once your CSV file is ready, it’s time to upload it to the Uome app. Here’s how:
- Open the Uome app and head to the “Expenses” section.
- Tap the ‘+’ button to add a new expense, and then select “Import File.”
- Choose the CSV file from your device, and once you’re ready, confirm the upload.
Step 5: Correcting mistakes
Don’t worry if you make a mistake. In Uome, you can always go back and edit an expense later if needed.
Step 6 – Avoiding duplicates
If your CSV file contains expenses that already exist in Uome, don’t worry. Uome will skip those duplicate entries to keep your records clean and tidy.
Step 7 – Matching your expenses
Uome is pretty smart! It’ll also match the expenses in your CSV file with any outgoing transactions you’ve already recorded in the app. That way, you’ll have a complete picture of your spending.
Step 8: Checking your imported expenses
After the upload is complete, you’ll see all your imported expenses in the Expenses module of the Uome app.
Step 9 – Running reports
Want to see how all this affects your income and expenses or get ready for tax time? You can run income and expense reports or tax reports to see exactly where your money is going.
And there you have it! Importing expenses into the Uome app is a breeze. Say goodbye to financial headaches and hello to simplified money management. Happy budgeting!