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 <[email protected]> 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 > [email protected] > > > > On Thu, Sep 27, 2018 at 1:31 PM Dimmick Library ILL <[email protected]> > 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 < >> [email protected]> 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 >>> [email protected] >>> >>> * 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 < >>> [email protected]> 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 >>>> >>>> >>>> >>>
