One thing you could do is run an invoice that has a date range that only includes the payments/credits you do not want. This will mark them as billed and then they won't show on the next bill. Timeslips include of payments/credits is an either/or, they are included or not included. However, if they are not in the date range of the slip transactions chosen and you choose not to include AR outside the range (from options) then it should obey the dates. What version of Timeslips are you running - go to help > about Timeslips. Perhaps there was an issue and it is has been addressed in a service release.

Hello rcorn65,

Yes, those can be a bit tricky. You are correctly tuned into the idea that the only way to limit the A/R transactions is to have them "obey the slip date filters." There is no separate filter for A/R date range on a bill, only the Slip dates.

Your issue may or may not involve the Bill Layout function, but it is unclear from your post.

When it comes to showing or not showing things on an invoice, it is VERY difficult to troubleshoot via an internet bulletin board.

The type of invoice you are describing is common when a business is billing a corporate entity and wants to send a more traditional "accounting" type invoice that only shows new charges. They do not want previous balance and payments, which are usually more of a traditional Statement and thus not shown on invoices. Showing prior balances and payments throws off the Accounts Payables clerk at the recipient. They key it wrong into their system and you end up with all sorts of overpayments later. Typically you are looking for something that shows only the "Total Amount of This Invoice," Is that what you are looking for?

Has technical support been helpful with this? Since you have Premium Elite, you should be able to get some support from Sage with it.

As a final option, if you would like, one of the services that I provide is one on one, remote desktop, third party assistance. I can call you and share your desktop and work through it with you. But as I am not a Sage employee, there would be a charge for that.

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.
404-325-9779

Hi there.  Yes, I did consider doing that but it's a lot of extra work just to do what seems should be a simple thing.  As I mentioned in my original post, I am using the most current version of TS and if I use the A/R obeys date range, I can filter out certain transactions (payments) but what is shown as the balance due on the Invoice doesn't mesh with that invoice--if you can follow.  For example, say an Invoice total is $100 and we have $50 apply to that from autopayment out of client funds transactions.  The bill will not simply come out looking like $100 less $50, total due $50.  It will show the actual A/R balance, not the balance due on the Invoice.  That's why I use the term "simple invoice". .  I have work arounds, one of which you suggested, just wanted to see if after all these years of me using TS, there was some magic secret out there that everyone else was using and that I was not aware of.  : )

Hi Nancy.  You and I have worked together before and I have presented this issue to you in the past and unfortunately, it appears that TS cannot do what I want it to do.  I believe the work around you suggested to me was to export the bill to Excel and then manipulate it that way.  Which is fine, most everyone, including myself has a work around that will achieve what I want.  As I mentioned to the user above, just wanted to see if there was a legit way to do it within TS.  I wish TS would come up with this option.  

Okay, so to prove/disprove the theory.

I opened the sample database in Timeslips Premium Elite, and created a new client. Nickname: RCORN65.

Entered a new Payment to Funds on January 10 of $500.

Added one slip dated January 10th for $150 worth of time. 

Changed the bill date to 1/31/2023, printed the bill to PDF and approved it. Did not draw any of the Funds to cover the bill, so the account still has $500 in Funds, but now has a Previous Balance of $150.

Now for the 2nd bill: Enter a second slip for $300 dated March 10th. A Payment dated February 12th of $150 paying the previous invoice, and a Payment from Account of $200 dated March 10th to partially pay the current charges on the new bill.

Total A/R Balance Calculation goes like this:

Previous Balance: $150

New Charges: $300

Payments received (2) for a total of $350

Balance Due $100

Here's what the initial run looks like (I have highlight the A/R Payment you do not want to see):

If I limit the A/R transactions to obey the slip filters and do nothing else:

Then the bill looks like this.

Note that the "A/R Transactions Obey the Slip Date Filter Range setting DOES work. It is excluding the February payment.

But the individual bill does not "add up" correctly to only the current new and unpaid charges.

But if we take out the Previous Balance and the New A/R Balance, then we get this:

Which is better, but there is no total due for this invoice. At this point, the EASIEST thing might be to just print to PDF, and use the Add Text option in your PDF editor to add the total manually to explicitly show it to the client.

But if I add a Customized Section to my layout to do that, I can get this:

A bit cludgy, but it works.

Caren's method could work two, but it is incorrect to categorically say that Timeslips cannot produce the invoice you desire.

It may take a bit more work, but it can. 

Nancy Duhon, Esq.
Duhon Technology Solutions, LLC
Master Certified Consultant for Sage Timeslips
LawPay Partnered Consultant
Providing individual Consultations and Third Party Remote Desktop Support - including older/unsupported versions.
404-325-9779
[email protected]