Billing Assistant shows inaccurate account balance

Hello All, 

Currently using TS2019. We have several files wherein when we view the "New Balance" from the Billing Assistant screen, it will show a balance. When generating pre-bills, this balance will also show. BUT, when we access "Accounts Receivable" from the toolbar for the same file, it will show all invoices and payments as being paid in full. Additionally, a balance does not show up on the A/R Reports. 

What am I missing? Why is the Billing Assistant numbers different than the actual A/R numbers? This is becoming problematic as pre-bills are showing large balances on accounts that are paid in full. I don't have any filters on that I know if. I tried using the Data Verification tool as well to "repair" any issues but nothing comes up. 

Appreciate any advice/support. 

  • 0

    This does happen sometimes due to data corruption. The first thing to check is that they do not show up at all on the AR report. If they show on the AR report with a plus and a minus and zero then you have payments that have not been applied and you want to go fix that by opening the payments and applying them. Assuming that is not the issue make a back up. Then go to file and choose verification. You want to repair the AR balance on each of the matters that have a problem. Do not run a repair on all matters. I would skip checking the balance needs repair and just repair it on the ones you know have an issue. Then go check the balances in billing. if everything is correct, you can proceed. If there are discrepancies, I would suggest restoring a back up and reaching out to a consultant like myself who can help in fixing in other ways. 

  • 0 in reply to Caren2

    Unfortunately, I have attempted the verification option and it indicated that there were no issues with the file indicated. 

  • +1 in reply to Lianne Hoffmann
    verified answer

    Sometimes even though it says no issue found, running the repair will fix the particular matter. Did you try that? Beyond that, it would require "hands on" to try to assist. 

  • 0

    Hello  and welcome to the Community.

    I don't disagree with anything  has already suggested.

    But I did want to point out that I would almost never expect the A/R Transactions Balance to match the Billing Assistant New Balance. So if you are comparing those two numbers and expecting them to match, you will be a bit frustrated. Especially when you have new charges.

    Your A/R Transactions Balance should match your Billing Assistant's Previous Balance minus any payments or credits. So, there is no one-to-one/always matching number in Billing Assistant that will jive with the current A/R Transactions Balance.

    In your screenshot, your Previous Balance is $2269.50, that number seems to be too high. (Assuming monthly billing and the client paying in full each month,) it should be $1195.50. Then you would receive the payment of that $1195.50 which would get you the Zero A/R balance, plus the new charges of $91.55 for a New Balance of $91.55.

    I would second Caren's advice about making a backup, and rebuilding just that one client's A/R balance and see if that helps.

    Nancy Duhon, Esq.
    Duhon Technology Solutions, LLC
    Master Certified Consultant for Sage Timeslips
    Providing individual Consultations and Third Party Remote Desktop Support - including older/unsupported versions.
    Co-Author of "The E-Billing Process Using Sage Timeslips©" available here: www.certifiedresourcesnetwork.com/
    LawPay Partnered Consultant
    MyCase Consultant
    404-325-9779
    [email protected]

  • 0 in reply to Nancy Duhon

    Nancy, thank you regarding that wording emphasis. It is important to distinguish between different types of balances - new charges vs total balance.