We do not have a ready to use tool to merge books (like merge transactions). Basically the steps to merge books are:
- Export data from a book
- Prepare data to import (optional)
- Prepare receiving book (optional)
- Import data in receiving book
Export all the transactions from a book with the Google Sheet Add-on for Bkper with Fetch. To make sure you get all the transactions in the search query you can put after:$y-10
Prepare data to import (optional)
With formulas (query, import, lookup) you can seperate receivables, payables etc. on seperate tabs and use the column titles of corresponding groups in the receiving book to auto create missing accounts.
Learn more about Auto create accounts
Prepare the receiving book (optional)
In this step you can create accounts and/or groups to reflect the balance values of accounts on the old book.
Import (Record) the data with the Google Sheets Add-on for Bkper on the receiving book.
Good practice is to start with just a few entries and adjust entries as needed so the Bookbot helps you as you start to import larger batches of entries.
For the reporting alternative what you do is you fetch relevant data per property on seperate tabs and create a consolidated report tab for the owner summing totals from the property tabs.