[OPEN-ILS-GENERAL] Cash Reports Accuracy

[Dimmick Library ILL]

That is so helpful! Thank you, Michele. I will try that source in my new
templates.

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




On Mon, Oct 1, 2018 at 9:40 AM Morgan, Michele <mmorgan at noblenet.org> wrote:

> Hi Sarah,
>
> The Payments: Desk source keeps track of Cash, Check, and Credit Card
> payments. If other payment types (Forgive, Work, Goods) are used when the
> payment is recorded, those receipts would not show up on that report.
>
> You could try a report using the Payments: All source to see if those
> other payment types are being used.
>
> Hope this helps,
> Michele
> --
> Michele M. Morgan, Technical Support Analyst
> North of Boston Library Exchange, Danvers Massachusetts
> mmorgan at noblenet.org
>
>
>
> On Thu, Sep 27, 2018 at 1:31 PM Dimmick Library ILL <dmljt.ill at gmail.com>
> wrote:
>
>> 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/20181003/4fc223ef/attachment.html>