How to Copy Multiple Billed Slips from One Client to a New Client as Unbilled Slips

SUGGESTED

We have finalized multiple bills (at least 10 going back around a year).  The client has paid our bills but I now find out that the bills need to be submitted in the LEDES98B format to an insurance company so that our client can be reimbursed.

What I want to do is copy all billed slips to a new client and then generate multiple invoices for the insurance company in the LEDES98B format. There are a few hundred slips that once copied will have to be edited to put in the missing ABA codes for billing and also be split in some instances to avoid block billing.  That's going to take a lot of time as it is.

Is there any way short of copying each slip manually and saving the new duplicate unbilled slip to a new client?  It gets very confusing when doing this one slips at a time and it's easy to overlook a slip or make two copies.  I would just like to be able to copy all slips for one client in a certain date range and the only thing that would change on the copied slips is that they would now be under a new client.

I did see a comment somewhere here about exporting slips (in over 25 years this is something I've never done), but it was stressed to make a copy of your database first and be VERY careful about what you were doing.

Thoughts?

  • 0

    The way I would do this is to export the slips and import them back on to the new matter. If you have never done imports This is beyond the scope of what I can describe in a forum like this, but it is something that I could help you with. it is not something I expect would take a lot of time, but there would be a charge. Feel free to reach out to me if you would like to discuss in more detail

  • 0
    SUGGESTED

    For me the test is always how many slips are we talking about, because the export/import takes some time and expertise, and therefore money. But you are correct that copying a lot of slips by hand is time consuming as well. Hence, the how many question, which can tell us if export/import is worth the effort. 

    Sounds like you have enough that export/import would be worth it if you are going back that far. Conceptually, you will export the slip data, and then build an import template to bring it back in as an open/unbilled slip on a new client.

    I would advise that you do this in a COPY of your database, because you likely don't want double the slips and invoices cluttering up your working database and messing up your reports. I might even just use a New Based on Current, and only have those slips in there to make things easier.

    As  mentioned, as consultants we do a lot more exporting and importing than an average user. I have done this type of export and import for this very same reason several times for various clients of mine.  But it just isn't anything that we can explain quickly or gratis here on the bulletin board. However, we are always happy to help folks get this done on their own systems via remote desktop connection and phone call. 

    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
    [email protected]

  • 0 in reply to Caren2

    Thanks for responding.  Since I have actually billed our client (and been paid) for all the slips I want to copy, I don't think I want to use the export feature since I want to leave my original billed slips as is.  I've started doing the copying of slips, one by one, and it's going okay.  The tedious part will be fixing the block-billed slips and adding the ABA codes to each slip.  

  • 0 in reply to crrlaw

    Just as an FYI, when we say export the slips, we mean export a copy of the slips. We would leave the billed ones as they are. So really export a copy, and then import them as unbilled against the new entity. Same effect as copying one by one.