Import Data from Sage Line50

[Patch]

@Pendu

I can see in the guide details for importing invoices for sales and purchases, Transaction for Bank. But I cannot see if its possible to import transactions of nominal [general] ledger accounts. Can this be done

This may help

How to batch import in manager

Some hints for batch creating. Most tab in Manager correspond to a different relational database tables The required data format for each tabs batch create is most easily determined by manually entering some data in that tab then doing a “Batch update”. Record links to other tables is done via a UUID. The UUID for most of theses links can be easily found by doing a batch update of the target database table / tab, the final field is the Key / UUID for that item. Exceptions include Tax…

It can be done. How much is actually done depends on the value a business places on having historical data in their new accounting system. How hard it is to do depends on what data is available on the old system and what you actually need to transfer across.

As for general ledger, my understanding is that’s a summary of all transactions. You will need to transfer/enter the data into the appropriate tab/database table in Manager. After which it will be include in the general reports in Manger

The easiest is to only transfer the starting balances from the end of the last financial year. And continue to use the old system for details on the old data. In practice users choose a start date, the real question is how much overlap is used between accounting systems.