Accounts receivables

JeanBJeanB Member Posts: 3
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.


  • gregaricangregarican Member Posts: 458 
    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 Member Posts: 1

    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 Member Posts: 458 

    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 -->

    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...

  • kalpakalpa Member Posts: 1

    Make no sense lightspeed,ones we run A/R report as of 12/31/19 even we selected 12/31 its showing balances as of today's date? 🤣

  • JeanBJeanB Member Posts: 3

    Hey Lightspeed!!

    When are you going to create a Receivables report that can look back in time? It's not rocket science ... all of the information is there. Get one of your "stellar" programmers on it. Here, I'll explain it to you:

    1) Take customer's balance as of today

    2) Add / subtract sales and payments made to the customer's account between today and a certain selected date in the past

    3) Now you have the customer's balance at a selected point in history

    You're able to produce an inventory report that follows these rules so please implement a usable receivable report.

  • VanessaDVanessaD Moderator, Lightspeed Staff Posts: 133 moderator

    Hi @JeanB ,

    I'll forward it to the dev team as a feature enhancement. Thanks for the feedback!


    If you have any further questions Please do not hesitate to contact LightSpeed support or check out our Support Page.


    Vanessa D.

    Lightspeed Retail Support

    866-932-1801 ext. 2 (Toll-Free)

    514-907-1801 ext. 2 (Montreal)

Sign In or Register to comment.