Accounts receivables

JeanBJeanB Posts: 1Member
I'm curious how other LS Retail users are reconciling their accounts receivables per their accounting systems to the accounts receivable in LS?  There is no report that will give a balance at a specific date (ie. month end or year end) and no report that will even allow me to see the customer's A/R transaction trail.

3 comments

  • gregaricangregarican Posts: 307Member 
    edited October 2018
    This has been a noted gap for us too. We have one of our companies on LS Retail, but thankfully they don't have a great deal of customer A/R. But if/when we'd implement LS Retail for our two other companies this gap is huge.

    What I'd foresee is our pulling transactional details via the API into an intermediary SQL DB table set. Then based on the timestamps I can create custom reports that roll up details up to the specified date (e.g. - year-end, month-end, etc.). It's a shame that LS Retail doesn't provide more comprehensive A/R reporting out of the box. Without this report we couldn't implement with our other two companies, unless we'd like incorrect financials and unhappy auditors. :smiley:
  • eaiacctgeaiacctg Posts: 1Member

    I am new to LS. Before making the commitment to move to this software, I was told there is an 'a/r monthly statement' to mail to our customers. This would show invoice #'s, total amount charged, with aging information that balances with the total due for the customer's account. I contacted LS support, only to find out that is not so. LS has no month end statement templets. Has anyone found such an a/r report to mail to customers? This is a vital issue for us, as we seek to remind customer what they owe. Tks!

  • gregaricangregarican Posts: 307Member 

    The upside of Lightspeed Retail is the API is comprehensive enough where functionality gaps can be achieved through it. For example, you could setup a a new payment type, call it In-House Charge. Let's say that payment type has an ID of 4. You could report out of it (big picture) out of the box based on something like this --> https://us.merchantos.com/?name=reports.register.listings.payments&form_name=listing&__sort=transaction_payment_id&__sort_dir=ASC&start_date=2019-07-01&end_date=2019-09-03&payment_type_id=4&register_id=-1&shop_id=-1


    But if you were looking to create a set of customer account statements for mail out to them like a form letter, and also provide statement transactional details...this would require constructing an API query and pushing it into some sort of HTML template, an automated document mail merge, or the like. I would imagine there are third party developers who could tackle this...

Sign In or Register to comment.