[OPEN-ILS-GENERAL] Cash Reports Accuracy

[Dimmick Library ILL]

Terran,

I made a new template using your fields, adjusting the date filter to a
range of dates instead of one day.
Unfortunately, the report was still inaccurate--the total was $62 below our
physical cash in the register.

Sarah MacNeill
Interlibrary Loan Coordinator
Dimmick Memorial Library
http://www.dimmicklibrary.org/
570-325-2131




On Thu, Sep 27, 2018 at 12:32 PM Terran McCanna <
tmccanna at georgialibraries.org> wrote:

> We have a report template for a single-day cash report that some libraries
> use if they need more detail than the built-in cash report:
>
> Source: Payments: Desk
>
> Display Fields:
> Payments: Desk > Cash Drawer > Workstation Name
> Payments: Desk > Payment Date/Time
> Payments: Desk > Amount Payments: Desk > Payment Type
> Payments: Desk > Payment ID
> Payments: Desk > Billable Transaction > User > Current Library Card >
> Barcode
>
> Filters:
> Payments: Desk > Payment Date/Time (Equals) (Date)
> Payments: Desk > Cash Drawer > Owning Library (In List)
>
> Terran McCanna
> PINES Program Manager
> Georgia Public Library Service
> tmccanna at georgialibraries.org
>
> * The GPLS office is in the midst of relocating offices. We may be reached
> by all of the current mechanisms during the transition, but to ensure the
> most prompt response, please use the Help Desk:
> https://help.georgialibraries.org
>
>
> On Thu, Sep 27, 2018 at 12:16 PM, Dimmick Library ILL <dmljt.ill at gmail.com
> > wrote:
>
>> Hi!
>>
>> At our library, using the report available in Administration -->
>> Workstation  --> Cash Reports has not been accurate; it's consistently much
>> lower than our physical cash. Our library uses a cash drawer (not a
>> register) and we only accept cash or checks as payments, so for
>> bookkeeping, we need to have the payments entered into Evergreen reconciled
>> with physical cash.
>>
>> We have been looking for a way to create an accurate cash report that
>> matches the amount we remove from the register and deposit weekly. I've
>> tried to systematically create an accurate report template (I'm up to test
>> template #25 so far) but none yet have been accurate as far as the cash
>> amount collected in the register.
>>
>> Additionally, working with cash/payment/billing templates has been very
>> confusing, as column labels such as "Total Paid" appear under so many
>> different source paths. Through process of elimination, I feel like I'm
>> getting closer to finding the correct columns (I've started working within
>> the ILS User core source--does that sound right? I've tried different
>> payments sources as well) but somehow there are still payments being
>> missed, and I don't know where to look.
>>
>> Does anyone have any tips or documentation they can share as far as
>> locating the correct columns to include in a template for an accurate
>> cash/payment report?
>>
>>
>> Sarah MacNeill
>> Interlibrary Loan Coordinator
>> Dimmick Memorial Library
>> http://www.dimmicklibrary.org/
>> 570-325-2131
>>
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20180927/cd430f71/attachment-0001.html>