LightSpeed POS for your Retailers that Love their QuickBooks for Mac

Comments (3)

Comment Feed

Also works with AccountEdge

LightSpeed works equally well with AccountEdge Pro for Mac and AccountEdge Network Edition for Mac, which may be a better solution for retailers who also need the added functionality offered by AccountEdge in areas where QuickBooks for Mac falls short.

Brent Blackburn more than 2 years ago

A National Advisor Network Member Inquired in their forum....

Murph -

I have recently taken on a client who uses Lightspeed, however, when we did the import into mac we had a few problems, which I'm not sure was a result of us not choosing the correct settings for the import or if it is a limitation of Lightspeed. The support at Lightspeed was a bit perplexed, too. Ideally, we would like to import the invoices as an end of day summary and not each individual transaction.

This client has a retail store and I don't want to have hundreds of JE's each day. The first few imports seemed to go fine, but then the data started importing in with the date we actually did the import and not the date of the transactions. (we are in clean up mode - going back to the beginning of the year) We do not need to have each individual trx entered separately and want the ease of end of day totals for the bank recs.Can you tell me what import settings your client uses? Any other best practices to be aware of?

Adapted from a NAN Member inquiry more than 2 years ago

You can only export Detailed OR Summarized Journal Entries.

You must choose the Export (option) to QuickBooks you want from the menu of LightSpeed Pro. You should be able to select either Detailed, or Summarized, Journal Entry export options (but this is one or the other, you can't switch between them during export).

The Detailed option should create an export which contains all transactions, for the transaction date range you select, as separate journal entries. This is the option you would need for 'open A/R accounts' if you are going to be tracking them in QuickBooks.

Unfortunately unlike QBPOS, which has an option for 'details if open accounts' and otherwise summary, LightSpeed is either Details or Summary, no combination option.

My client (referenced in this story) has always used this 'detailed' option because their back-office wanted as much detail as possible in their QuickBooks file.

If you select the Summarized export option then, as I understand it, all the Invoices for the entire selected date range will be imported in summary as a single journal entry with a date as of the last date of date range for the export, not the transaction date of any specific transaction.

In other words this 'Summarized option' is a 'batch approach' and the import date corresponds to the latest date in the batch.

In either Detailed or Summary export options, all your other transactions like inventory adjustments are always treated as separate journal entries, but the date principle still applies based upon the option chosen.

I recommend that you make sure that you are selecting only a 'single date' in the date range, we also noticed that funky things can happen if you import more than one 'day's business' at a time.

I can't begin to tell you if any of these options change if you are running the multi-store version, or are using the integrated ecommerce functions, or are using the 'cloud' based version of LightSpeed, as my experience has been limited to a single-retail store running LightSpeed Pro.

Best of luck,

Murph more than 2 years ago

a small ad separator
IA Newsletter BL
a small ad separator
a small ad separator
a small ad separator
a small ad separator
Built with Metro Publisher™