[OPEN-ILS-GENERAL] Cash Reports Accuracy

[Morgan, Michele]

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/20181001/203220bf/attachment.html>