Question

Accounts Receivable

Laserfiche

Updated August 1, 2014

asked on July 30, 2014

Anyone have experience with using Laserfiche in accounts receivable? Specifically, what we're looking to do is have all EFT, Check Deposits scanned into Laserfiche and routed. Once everything goes through the process for that day...the VP of Accounts Receivable wants to be able to see the total amount of reconciliation for that day's batch (in their accounting system), and then search Laserfiche to know that all the checks/efts have been scanned in...so what he wants to do is compare the total dollar amount from Laserfiche with total dollar amount for PeopleSoft. The issue is, the EFT's are basically a printout from the Bank...so there's multiple transactions on each page so I can break them out and have 1 page per transaction with a total. Also, with the checks, the issue is that once the batch is first created (and the total $$ of the check deposit) is entered into Laserfiche...they then break the check out...so what would have to happen is the amount in the "Batch Template" would have to be reduced by the amount of each check that get's broken out so that the totals stay the same (can't have a batch for $10,000) and then break a check out and have that total be $2,000) otherwise my total would be $12,000. There's a lot going on in this situation and just curious if anyone has done anything with AR and how they might "Validate" that all the transaction info/checks have been scanned into Laserfiche to backup what's in the Accounting system.

Thanks!!

0 0

Replies

replied on July 30, 2014

What tools do you have available? Quick Fields? You can do some calculation inside there if you had it. Can you go through the process of how the checks are broken out? its a bit confusing.

0 0

replied on July 31, 2014

Sure...so initially they get a report from the bank that shows the total of all check deposits and total for EFT's. They then print a copy of all the checks from the bank as 1 batch (might be 200 pages) and assign it a batch # and the total $ for those group of checks. The batch then goes to a Cash Rep who then sorts through that batch of checks and if the check matches, then reconcile it (file it), if it doesn't...they then will assign that check to a Collections Rep who will further investigate. So basically what starts as 1 batch (and there can be many for 1 day) eventually get's broken out, but still is considered a batch. As for tools, this is an existing customer who is looking to expand to another Dept...so we can add any tools necessary to the solution to make this happen. My concern is again, if I have a batch totaling $10,000 (which is made up of multiple checks) as I break that out, how do I break out the amount of the check so that the total of all the checks still equals $10,000 even though they are now separate documents.

0 0

replied on July 31, 2014

If you dont need any help with how to do the calculations, then maybe use a secondary field on the Check Template. This would be something like a Check Batch Amount, and then a Current Check Amount. This way you store the individual value and also the total value.

1 0

replied on August 1, 2014

Hi Daryl,

If your question has been answered, please click the "This answered my question" button on the response.

If you still need assistance with this matter, just update this thread. Thanks!

0 0

You are not allowed to follow up in this post.

Question

Question

Accounts Receivable

Replies

Sign in to reply to this post.