Page 1 of 1
Importing Expenses & Reconciling Bank
Posted: Thu Mar 11, 2021 8:43 am
by jamesplanb
Is it possible to import a CSV file of expenses?
Also, if some of the expenses have been paid from a personal rather than the business account, how does the system handle reconciling these?
Thanks
Re: Importing Expenses & Reconciling Bank
Posted: Thu Mar 11, 2021 8:45 am
by jamesplanb
Also, assuming it is possible to import a spreadsheet of expenses, is it then possible to attach scans of receipts to the individual expense entries afterwards.
Re: Importing Expenses & Reconciling Bank
Posted: Thu Mar 11, 2021 8:55 am
by roy
Hello James
Thank you for your question
There isn't a dedicated location for importing expenses in that fashion. You could import them via the bank statements page but then you will have duplicates when you come to import your bank statements
Please see the following Knowledge Base article for recording payments via a different account
https://landlordvision.userecho.com/en/ ... nk-account
Once your expenses are in the system, you can then add receipts to them. Alternatively, you can upload the receipts to Property Manager > Scanned Receipts and create the expenses from those
Kind regards
Roy
Re: Importing Expenses & Reconciling Bank
Posted: Thu Mar 11, 2021 9:02 am
by jamesplanb
Is there no import service for people moving over to LV from elsewhere?
Re: Importing Expenses & Reconciling Bank
Posted: Wed Mar 24, 2021 4:52 pm
by roy
Hello James
The import options in Landlord Vision are as follows:
Portfolios > Import Properties and Tenancies from CSV File. Allows you to import the properties with addresses, the name of the tenant and create a payment schedule for each one. No historical data is imported
Account Manager > Bank Accounts > Open the bank account > Bank Statements tab > Import Bank Statement. Allows you to import payment data, usually a bank statement. Files can be imported in QIF, OFX or CSV format
Kind regards
Roy