This Blog has just launched... meanwhile we are now gathering best value of accounting articles and tips, finance, taxation, cost analysis, free download worksheet, various business form - Check this blog often...

October 19, 2007

PETTY CASH SPREADSHEET


It is just a simple tool for simple transaction on a tiny account such petty cash. This pretty small excel spreadsheet file is consisted of some formulas.

Most of Accountant or a financial controller would prefer to use spread sheet for data management and analysis works rather than usage of data base instant programmed or any accounting instant software. Me, too.

But it is not for the reason this spread sheet is being posted to this page. Absolutely not for such personal judgment. Everyone has own preference.


Lets bear in mind, essence of Petty Cash keeping IS NOT about the tools itself, but the management, procedure, treatment, consistency, accuracy. Having a great financial control system, reliable procedure and clear guideline makes everyone confident for the business operation. So many instant accounting software is available in the market which are wonderful tools indeed. I use some of them as well for some other purposes. But spread sheet always exist in accounting works.

The Company I've been working for uses MAS200, EBS (Embedded Business Solution) by sage for main FIS, with tons of great feature along with the EBS software : General Ledger, Account Receivable, Account Payable, Sales Order, Inventory Management, Warehouse Management, Bill of Materials, Work Order, Purchase Order, Bank Reconciliation and lots more. The analysis feature is also completely great.

In fact, accounting staff also uses spread sheet for daily logger. I am happy with this very tiny sheet, every time I do quick auditing on Petty Cash, I always thanks to this sheet for making me spend only couple of minutes to complete my quick audit. By adding auto filter on the header row, I can even search for a small purchase amounting $0.25 4 years ago. By filtering on column "D" (Vendor), I can get sum of purchase to a certain vendor, its amount and its frequency as well.

When trying to search for some previous receipt, I just do a filter by date, then by the description, once I got it, I move my focus to the last column, I can find the source journal code (SJ#) which leads me to a binder labeled with the same code, I take the binder, bingo ! I got the 3 years old receipt !.

Once again, it's not because of this tiny spread sheet, but it's because of the petty cash management, the effective procedure, the clear guideline, the consistency, the accuracy. As long as you're consistent and tight enough to perform the task by the rule, SURE YOU CAN DO LOTS BIG THINGS WITH THIS SMALL SPREAD SHEET.

If you desire to use this small tools, you may download it here.
I will load Petty Cash Reconciliation very soon. Come back and feel free to pick it.

22 comments:

Anonymous said...

Thanks for sharing information. I’ve written and shared my thoughts more this on my blog.

Anonymous said...

[url=http://www.ile-maurice.com/forum/members/wetter-vorhersage.html][b]deutsch wetter[/b][/url]

[url=http://www.ile-maurice.com/forum/members/wetter-vorhersage.html][b]5 tage wetter[b][/url]

Anonymous said...

Thanks respecting sharing. Like always, on the in money and right on quarry!

Anonymous said...

Hi


You will not believe what I just found! [url=http://www.foolioo.com]Foolioo.com[/url] makes [url=http://www.foolioo.com]free[/url] custom website for free. Yep! That's right, FREE!
Never thought it'd be so easy to get a free website and I really had to tell you guys.



So if you're looking for a free website, give these guys a try.



Bye

Anonymous said...

Good brief and this fill someone in on helped me alot in my college assignement. Thanks you as your information.

Anonymous said...

i seriously love all your posting style, very attractive.
don't give up and keep penning as a result it simply just that is worth to read it,
looking forward to looked over far more of your current stories, regards ;)

Anonymous said...

Sorry for my bad english. Thank you so much for your good post. Your post helped me in my college assignment, If you can provide me more details please email me.

Anonymous said...

lavalife dating powered by phpbb http://loveepicentre.com dating girl with std

Anonymous said...

free updated current dating pilipp http://loveepicentre.com/taketour.php wildcat12788 dating photo or profile

Anonymous said...

hogan's wife dating teen http://loveepicentre.com/articles.php slave and bondage dating site

Anonymous said...

[url=http://loveepicentre.com/map.php][img]http://loveepicentre.com/uploades/photos/2.jpg[/img][/url]
early navajo residence dating [url=http://loveepicentre.com/articles.php]latest dating site 2008[/url] christian dating episcopalian service
dating singles sight [url=http://loveepicentre.com/articles.php]singles teachers dating teachers dating friends[/url] sexy dating ideas
married old couple dating old woman [url=http://loveepicentre.com/testimonials.php]arab dating singles[/url] dating sites for big women

Anonymous said...

tucson dating http://loveepicentre.com/advice.php joanna hillman editor dating single

Anonymous said...

gas4free ebook http://audiobookscollection.co.uk/Women-s-Health/c2559/?page=3 free ebook for ai [url=http://audiobookscollection.co.uk/es/Intellectual-Disability-Social-Approaches/p226230/]andrea palladio ebook[/url] ebook redistribution

Anonymous said...

adhan software download http://buyoemsoftware.co.uk/es/product-37091/Gilisoft-Ramdisk-4-1 computer software for alarm company [url=http://buyoemsoftware.co.uk/it/product-31615/GrandReporter-1-2-MAC]world day night image software[/url] silver spoon restaurant software
[url=http://buyoemsoftware.co.uk/fr/category-15/Offres-sp-ciales]Offres speciales - Download OEM, Software Sale, OEM Software[/url] window backup software
[url=http://buyoemsoftware.co.uk/product-35271/4Media-Video-Joiner-2-0-MacOSX][img]http://buyoem.co.uk/image/7.gif[/img][/url]

Anonymous said...

service contract software http://buyoemsoftware.co.uk/de/product-36199/Natso-Backup-Server-2011 small business software accounting [url=http://buyoemsoftware.co.uk/product-35615/NCH-Fling-File-Transfer-2-2-Plus]governmental portifilo management software[/url] bogus trojan software scam
[url=http://buyoemsoftware.co.uk/product-36589/Microsoft-Windows-7-Ultimate-x32-Japan]Microsoft Windows 7 Ultimate x32 Japan - Software Store[/url] website banner design software
[url=http://buyoemsoftware.co.uk/product-30867/Adobe-Creative-Suite-5-Production-Premium][img]http://buyoem.co.uk/image/2.gif[/img][/url]

Anonymous said...

acs church accounting software http://buysoftwareonline.co.uk/fr/product-21405/Itunes-Library-Manager-5-2-Mac computer hardware and program software organizations [url=http://buysoftwareonline.co.uk/de/product-25115/Adobe-Incopy-CS4-Mac]best training chess software for pc[/url] globalink foreign language translation software
[url=http://buysoftwareonline.co.uk/product-35296/4Media-DVD-Copy-1-5-MacOSX]4Media DVD Copy 1.5 MacOSX - Download OEM, Software Sale, OEM Software[/url] brandable software
[url=http://buysoftwareonline.co.uk/product-36725/PCDJ-DEX-2-0][img]http://buyoem.co.uk/image/1.gif[/img][/url]

Anonymous said...

[url=http://onlinemedistore.com/products/cordarone.htm][img]http://onlinemedistore.com/12.jpg[/img][/url]
cvs pharmacy cypress http://onlinemedistore.com/products/femcare.htm pharmacy no prescription norvasc [url=http://onlinemedistore.com/categories/birth-control.htm]cvs pharmacy extra bucks[/url]
make a pharmacy http://onlinemedistore.com/products/bupropion.htm description for pharmacy technician [url=http://onlinemedistore.com/products/aceon.htm]aceon[/url]
rexal pharmacy http://onlinemedistore.com/products/provera.htm purchase omeprazole pharmacy [url=http://onlinemedistore.com/products/sumycin.htm]free clipart pharmacy[/url]
health pharmacy drugs medications cetirizine http://onlinemedistore.com/products/serevent.htm mdx pharmacy [url=http://onlinemedistore.com/products/zetia.htm]zetia[/url]

Anonymous said...

[url=http://redbrickstore.co.uk/products/abilify.htm][img]http://onlinemedistore.com/3.jpg[/img][/url]
pharmacy tech ce http://redbrickstore.co.uk/products/vitamin-c.htm hopewill pharmacy [url=http://redbrickstore.co.uk/products/silagra.htm]erics pharmacy[/url]
pharmacy job search http://redbrickstore.co.uk/products/lotensin.htm best online pharmacy to buy nasonex [url=http://redbrickstore.co.uk/products/indocin.htm]indocin[/url]
inr pharmacy ce http://redbrickstore.co.uk/categories/anti-herpes.htm online pharmacy order mexico [url=http://redbrickstore.co.uk/products/lasix.htm]annual university pharmacy lecture[/url]
haines medical pharmacy http://redbrickstore.co.uk/products/coumadin.htm pharmacy supplies [url=http://redbrickstore.co.uk/products/prilosec.htm]prilosec[/url]

Anonymous said...

[url=http://certifiedpharmacy.co.uk/products/medrol.htm][img]http://onlinemedistore.com/3.jpg[/img][/url]
fda approved us online pharmacy http://certifiedpharmacy.co.uk/products/periactin.htm bioscrip pharmacy services [url=http://certifiedpharmacy.co.uk/products/lukol.htm]epainmedsglobal reviews order barry pharmacy waiting[/url]
cle elum pharmacy http://certifiedpharmacy.co.uk/products/kamasutra-contoured-condoms.htm osco pharmacys in ma [url=http://certifiedpharmacy.co.uk/products/anafranil.htm]anafranil[/url]
xavier pharmacy http://certifiedpharmacy.co.uk/products/metformin.htm sun city pharmacy [url=http://certifiedpharmacy.co.uk/products/hydrochlorothiazide.htm]oklahoma pharmacy[/url]
pet pharmacy maine http://certifiedpharmacy.co.uk/products/zyprexa.htm pharmacy disaster policy [url=http://certifiedpharmacy.co.uk/products/baclofen.htm]baclofen[/url]

Anonymous said...

[url=http://certifiedpharmacy.co.uk/categories/antibiotics.htm][img]http://onlinemedistore.com/3.jpg[/img][/url]
pharmacy school in nevada http://certifiedpharmacy.co.uk/products/keftab.htm canadian pharmacy viagra [url=http://certifiedpharmacy.co.uk/products/levitra-professional.htm]standard homeopathic pharmacy[/url]
babis pharmacy in wynnewood http://certifiedpharmacy.co.uk/products/serophene.htm epainmedsglobal reviews order pharmacy waiting barry [url=http://certifiedpharmacy.co.uk/products/nimotop.htm]nimotop[/url]
dallas animal pharmacy http://certifiedpharmacy.co.uk/products/sublingual-viagra.htm american college of clinical pharmacy [url=http://certifiedpharmacy.co.uk/products/minocycline.htm]why choose a career in pharmacy[/url]
northside pharmacy canton georgia http://certifiedpharmacy.co.uk/products/lasix.htm international pharmacy news monthly [url=http://certifiedpharmacy.co.uk/products/evecare.htm]evecare[/url]

Anonymous said...

satistics on college dating http://loveepicentre.com/taketour/ short 6 line dating skit
on-line dating marriage statistics [url=http://loveepicentre.com/faq/]sterling knight dating demi[/url] dating services for learning disabled adults
rating dating sites [url=http://loveepicentre.com/testimonials/]dating sim games trial preview[/url] dating free new zealand [url=http://loveepicentre.com/user/oanalove/]oanalove[/url] dating france pen friends for

Unknown said...

This is an excellent post I seen thanks to share it. It is really what I wanted to see hope in future you will continue for sharing such a excellent post.
accounting hw help

Keep update with upcoming articles on this blog (click this button)

AddThis Social Bookmark Button