Cash Receipt Summary vs Revenue by GL Code Reports

Manager SE Reports & printing
User avatar
ricmorin
5K Holy Smokes Contributor
5K Holy Smokes Contributor
Posts: 5967
Joined: Mon Jul 25, 2005 10:11 am
Location: New Hampshire
Contact:

Re: Cash Receipt Summary vs Revenue by GL Code Reports

Post by ricmorin »

We have 200 in the drawer and use a separate sheet to reconcile that nightly. That sheet is attached to the daily closeout bundle.
Ric Morin - Volunteer Forum Moderator, Shop Owner, ASE Master L1
Motorcar Alternatives, LLC
603-622-6434 x203
www.motorcaralternatives.com

I find my life is a lot easier when I use Special Orders
tmbutitta
25 Club: Starting Contributor
Posts: 45
Joined: Tue Apr 07, 2015 7:12 am

Re: Cash Receipt Summary vs Revenue by GL Code Reports

Post by tmbutitta »

Would you share your daily close out process and bundle?
User avatar
ricmorin
5K Holy Smokes Contributor
5K Holy Smokes Contributor
Posts: 5967
Joined: Mon Jul 25, 2005 10:11 am
Location: New Hampshire
Contact:

Re: Cash Receipt Summary vs Revenue by GL Code Reports

Post by ricmorin »

Absolutely!

Reports printed are split into two packages. One for inventory and one for accounting. Reports printed are....
  • Balances Due
    Cash Receipts by Payment Type
    Deleted Orders
    Deleted Payments
    Discount Summary
    Invoice Profit Summary
    Posted Orders
    Committed Parts by Part No
    Low Inventory by Part No
    Low Inventory by Vendor
Our cash out form...
Daily Cash Out Form.docx
(13.88 KiB) Downloaded 126 times
Our daily 'Sales' will be entered into QB from the Cash Receipts by Payment Type report. Deposit receipts and batch reports from cc are attached and checked to match. The cash out form is also attached. The whole package, once all paperwork is obtained, is scanned and filed. Paper is kept for seven years, then shredded. Scans are kept forever, but my plan is to move anything more than ? years old to a removable SSD.
Ric Morin - Volunteer Forum Moderator, Shop Owner, ASE Master L1
Motorcar Alternatives, LLC
603-622-6434 x203
www.motorcaralternatives.com

I find my life is a lot easier when I use Special Orders
tmbutitta
25 Club: Starting Contributor
Posts: 45
Joined: Tue Apr 07, 2015 7:12 am

Re: Cash Receipt Summary vs Revenue by GL Code Reports

Post by tmbutitta »

that is perfect! thank you for the help. its very similar to what i do, minus the inventory and quickbooks stuff.

BUT i would still love a way to account for the difference between the cash receipts by payment type and posted orders.
User avatar
timbre4
System Guru / Moderator
System Guru / Moderator
Posts: 4456
Joined: Tue May 25, 2004 5:47 pm
Location: TN - Volunteer State

Re: Cash Receipt Summary vs Revenue by GL Code Reports

Post by timbre4 »

As for the report differences, please take a look at example #2 in the Why Report #s Don't Match PDF attached. It might shed some light about differing factors in calculations.
Attachments
Why Report #s Dont Match 2014.pdf
(157.74 KiB) Downloaded 122 times
Tim McDonnell -
Sr. Product Market Mgr / Forum Moderator / Mitchell 1 Media Developer
Locked

Return to “Reports + Printing”