Lightspeed - Import movements .csv (Banana+ Advanced ) [BETA]

This import extension allows you to import your Lightspeed transactions into Banana. You can install the extension from the menu Extensions->Manage Extensions.

Requirements for use

• Banana accounting Plus with the Advanced Plan.
• Double-entry accounting files with VAT, you can create a new one or use an existing one.

Export procedure

Export your transactions in *.csv format by accessing your Lightspeed account. 

• Log into your Lightspeed account with your username and password.
• Via Reports → Reports → select Operational report.
• Select the desired export period.
• Display the Accounting view.
• Click on the button Export in CSV → select Export to Winbiz.

Import procedure

• Open your accounting file (*.ac2).
• Via the Actions → Import to accounting → select Import transactions box.
• Choose the extension to be used, in this case 'Lightspeed - Import movements .csv (Banana+ Advanced) [BETA]'.
• With the Browse button, choose the file from which to import the transactions.
• Press OK Button.
• Check the preview of the changes thanks to the dialogue that is proposed to you, press OK if everything is correct otherwise press Cancel if you have seen any errors, at which point correct any errors and repeat the process from the first point.

Set up your accounting

Transactions are imported into the Transactions table.

After the import, it is necessary to manually complete some information on the imported data. If immediately after the import, errors appear in the record tables, no problem, they will disappear once the imported data is completed with the missing information.

Accounts Table

All accounts used in imported transactions that do not exist in the chart of accounts in Banana are automatically added to the bottom of the table. The information for the new imported accounts must be completed:

• You can move the account by repositioning it in another row.
• Check that the BClass automatically set during import is correct.
• Set the correct grouping in the Sum In column.
• Set the correct account currency. *

*Set the correct currency also to those accounts that were already in the chart of accounts in Banana but with a different currency than the one assigned to them in Lightspeed.

See accounts management in Banana: Accounts.

VAT Table

Some of the VAT codes used in imported transactions are automatically recognised and converted into VAT codes used by Banana, unrecognised codes are inserted at the bottom of the VAT table as new elements and you can choose to:

• Complete the VAT code information and create a new rate within the table, below is an explanation of how the VAT table is structured: VAT Codes Table.
• (RECOMMENDED) Check whether the new VAT rate entered already corresponds to one of the existing VAT rates, there is probably already an identical rate that suits you, in that case, you must update the rows in the Transactions table that refer to the old code and replace it with the new one, to do that you can use the Find and Replace function. Once you have finished the replacement in the records table, you can delete the rows with the old codes.

In the Transactions table you may see some errors or warnings concerning the registration of VAT:

• due VAT/Sales tax is not entered correctly: This problem can be solved by using Banana's VAT codes, or alternatively by indicating in the VAT code table for the given code whether VAT is due or not.
• Warning: due VAT/Sales tax is not entered correctly: In the transactions, it seems that the due VAT is entered oppositely to what it should be, but it may not necessarily be an error. This situation may occur, for example, with cancellations or adjustments.

See VAT management in Banana: VAT Management.

Check accounting

At this point your accounting in Banana is ready and should no longer present any problems, you can perform a further control by checking and  recalculating your accounting.

Error Messages

• Unrecognised file format: The format of the file you are trying to import does not match the *.csv format associated with this filter:
  • Check that you have chosen the correct file.
  • If the file you have chosen is correct, it may be that our filter requires updating.
• This extension requires Banana Accounting+ Advanced: You are trying to use the extension with a licence other than the one requested, please upgrade to the Advanced Plan to be able to use the functionality of this filter.

For any other errors or questions about the import, you can send us a feedback.

Send us a feedback

It may happen that the format of the *.csv file is updated and as a result the filter no longer functions correctly. Send us feedback and attach an example file (*.csv) with the new format and we will proceed to update the filter.

This is also a BETA version, which means that is not the final version of the filter, contact us if you would like to propose:

• Tips on how to improve import.
• Test files exported by Lightspeed (*.csv).
• Any errors that were not reported or described in the documentation.