Accounts receivables

JeanBJeanB Member Posts: 5
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: 702 
    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: 702 

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

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

    All the best!


    Lightspeed Retail Support

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

    514-907-1801 ext. 2 (Montreal)

  • ATjessicaATjessica Member Posts: 5

    Just popped in to say this is still a MAJOR issue.

    I hear about it daily from our accounting department... please fix this!!

  • TcNurseryTcNursery Member Posts: 16

    You can try this.

    Getting the work orders to act like invoices. 

    This is what we came up with in a "work order template" ( I can send it to you if you would like)

    In Workorders/Service

    -When you change the status to finished it changes to BILL in the right hand corner.

    -You can set the Due Date for sending out bills. 

    -The way I use it, When the job is finished and Im ready to send out the bill, I set the "Date In" to the day I sent out the bill and the "Due Date" to when it is due then I type Billed in the "Hooked out box" to know that I sent the bill out. Now you can just look at your finished projects and know its your Accounts Receivable, plus if you need to change anything before it become an invoice now it can be changed.

    -This works for printing out the bills and just do a quick fold and put it in a window envelope #9 and drop it in the mail, also if the customer made a deposit It will show the deposit. If they added any product to the work order after the deposit it will show the remaining balance.

    I Hope This Helps

  • JensBachJensBach Member Posts: 5

    Does anyone work on Lightspeed Retail? We have suggested several easy and very useful updates to the software, that would greatly improve the user experience, but since March 2021 nothing has happened. At least with Onsite we were able to see some regular improvement. An AR report LSR is a must and should be readily available to us business owners. Getting very tired of the non-action.

Sign In or Register to comment.