Do you trust your financial statements? Reconciliation tools for Online Retailers

Do you trust your financial statements? Does your cash account in Quickbooks match your bank statement? Would you like to reconcile costs with sales on an order/product levels and see how profitable your business really is?

Practically every company I work with desperately needs real time accurate financial data to make best pricing and marketing decisions and Quickbooks wasn`t simply designed to handle tens of thousands of transactions, follow a "reasonable proof of shipment" revenue recognition rule or accrue for cost of goods invoices due in 30-90 days. So, what`s the best way to do managerial accounting in the high velocity negative cash cycle online retail world?

Periodic audit is one way. This is the best solution if you are entering into a business deal and need an external verification of your numbers. Downsides are:
  • A $10-15K fee for something that was obsolete before it was completed;
  • High internal costs (e.g. having your accounting department paralyzed for 2-4 weeks);
  • You have to do everything all over again every time you need accurate financials.
A massive export of transactional and financial data to Excel is a better option. However manual and time consuming, you reconcile tens of thousands of orders with appropriate costs, get to the real margins and can identify the products that either have too much margin built in or too little. Downside - maintenance becomes an issue. Once the person who built the table moves on to other projects - the system becomes less and less accurate and you lose the temporary advantage over competitors.

The very best solution is a database connected to your Order Management, Quickbooks and shippers` billing systems. There are multiple buzzwords for something that stores the data and produces reports: Data Warehouse, Business Intelligence, Business Warehouse etc. For simplicity I will call it by it`s primary function - a reconciliation system.

Benefits of reconciliation system are numerous:
  • Verification of your company`s tax return numbers;
  • Practically real time vendor/ product margin analysis;
  • Easy way to compare accruals with actual expenses (COGS, Shipping, Marketing etc).
Having built such systems for two clients I highly recommend starting with a standalone solution, replicating your chart of accounts, fine-tuning allocation rules and check consistency of the data. Then test on a large amount of historical data (e.g. FY2008) and compare with your year-end results. Since we have replicated your chart of accounts - comparison is easy, just print P&L statements from QuickBooks and the reconciliation system and compare them account-by-account. I bet there will be a lot of interesting discoveries.

In addition to accurate historical statements such system gives you a real edge over the competitors. You become able to make pricing and investment decisions on the fly.

Let`s say you want to experiment with a free shipping - run it on a product category (or a store) for two weeks. Compare sales/ net margin with prior two weeks and see if free shipping is the right solution for this particular product set.

Or, throw in free gift-wrapping for one week and see if you should keep it for the rest of the holidays season.

Or, reduce your target margin from 30 % to 28 % and see what impact it has on your sales/ total net margin for the specific product line. Opportunities are endless.

I believe that systems should help people manage complex businesses through simple decisions such as Set target margin at X %, add free shipping or spend Y % of sales on PPC marketing. Therefore, every system I build addresses a specific need:
  • Reconciliation system to get accurate financials and identify products with excessive/ inadequate margin requirement;
  • Shipping script to calculate per product shipping costs using negotiated rates with the shippers;
  • Pricing script to automate retail price calculation based on actual costs and target margins; and
  • Product sourcing solution to enable retailers build "One Store A Day" and double their sales every three months.
If you have questions about one my solutions - please send me a note to or call at 650 209 6570. My clients win - I win.

Have fun growing your business and happy holiday season.

Labels: , , , , ,


Blogger shri hari said...

Nice! Really cool stuff and very inspiring. Thanks for sharing!
Web Designing Company In Chennai

March 27, 2015 at 6:28 AM  
Blogger Lucy Grace said...

Very informative post! Quite interesting to read your blog.

April 12, 2015 at 11:29 PM  
Blogger Anitha Raj said...

Very detailed article. Happened to learn some new things from this. So thanks.

Web Designing Training in Chennai

July 31, 2015 at 9:58 PM  
Blogger HOW -2 DO said...


September 12, 2015 at 8:26 PM  
Blogger Rashida Panxpan said...

Yes I trust financial statement. If this type of statement made correctly it can help find out business overall revenue and other expenses analyze. Glad to learn some effective ways to grow business and all! Part of the solution is making sure everyone on your team is on the same page in regards to business revenue and expenses. Collaboration via analytics tools such as Panxpan finance summary module can help with this.

September 13, 2015 at 9:19 PM  
Blogger Diana Azura said...

Great post. I really enjoyed reading it. So thanks.

school logo design

October 7, 2015 at 3:54 AM  
Blogger Maha Lakshmi said...

You shared very useful post. Thanks for sharing.
Catering Services in West Mambalam

October 28, 2015 at 11:09 PM  
Blogger Sri Sathvika said...

Good post. very informative, Thanks for sharing this post.
SEO Training Certification

October 29, 2015 at 9:29 PM  
Blogger Jeanne Davies said...

world-wide-web development can be highly popular for the industry due for its various advantages. several companies tend to be looking for secure, speedy, compatible world-wide-web development website design services

March 23, 2016 at 11:50 PM  
Blogger Camellia Canan said...

Superb i really enjoyed very much with this article here. Really its a amazing article i had ever read. I hope it will help a lot for all. Thank you so much for this amazing posts and please keep update like this excellent article.

SAP training in Chennai

April 6, 2016 at 3:43 AM  
Blogger Deborah Richards said...

wow, great, I was wondering how to cure acne naturally. and found your site by google, learned a lot, now i’m a bit clear. I’ve bookmark your site and also add rss. keep us updated. flipkart offers & coupons

May 3, 2016 at 12:24 AM  
Blogger Red Safety said...

The information shared is very useful for us, thanks for sharing Nebosh course in Chennai|
NEBOSH International Diploma|NEBOSH International General Certificate|IOSH Course in Chennai|Nebosh course in Dubai|NEBOSH International Diploma in Dubai|NVQ Diploma|NEBOSH IGC in Dubai

May 17, 2016 at 1:40 AM  
Blogger Maya Mukharjee said...

Thanks for sharing this Post, Keep Updating such topics.

May 26, 2016 at 11:15 PM  
Blogger Emma David said...

Thanks for the post and keep posting more like this Nebosh courses in Chennai| Nebosh course in Chennai| Nebosh course in Dubai | BSS Safety Diploma

June 4, 2016 at 1:14 AM  
Blogger Raju Kumar said...

web designing company in Hyderabad ,Web designing is nothing but creating a website. In 1990’s, World Wide Web came in to picture, in those days may be

web designing company in hyderabad

June 27, 2016 at 4:59 AM  
Blogger sonnes leen said...

Thanks for sharing such a nice article. It is really useful to me and all people. One think in my mind came while reading that it is not wasting of time.

July 5, 2016 at 1:58 AM  
Blogger deeksha said...

your economy articles are really good and thus it makes me to think , how to invest in many more ways and it is very much cumulative and eminent too.

Salesforce Training in Chennai Adyar

July 5, 2016 at 11:41 PM  
Blogger sonnes leen said...

thank you for the information here. It was much useful and please keep update like this.
Voice Over Agents

July 11, 2016 at 2:40 AM  
Blogger Angel said...

This is a wonderful article, Given so much info in it, These type of articles keeps the users interest in the website, and keep on sharing more ... good luck.granite supplier in india

August 3, 2016 at 11:13 PM  
Blogger Angel said...

Such a very useful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article.affordable luxury travel

August 3, 2016 at 11:13 PM  
Blogger Angel said...

I want you to thank for your time of this wonderful read!!! I definately enjoy every little bit of it and I have you bookmarked to check out new stuff of your blog a must read blog!!!! Angel investment in India

August 3, 2016 at 11:14 PM  
Blogger jowdjbrown said...

A debt of gratitude is in order for giving late reports with respect to the worry, I anticipate read more. Buy Dissertations

February 25, 2017 at 8:33 AM  
Blogger Evelin Harriet said...

I like it your blog. Thank you for Sharing the valuable information!
erp in chennai | erp providers in chennai

March 13, 2017 at 12:11 AM  
Blogger Shivani Yuvanjalin said...

Really Nice Blog. Thank you for Sharing. We are the best erp software providers in chennai. For more details call +91 9677025199 or email us on
ERP Providers Chennai | ERP in Chennai

March 13, 2017 at 1:42 AM  
Blogger jowdjbrown said...

It was good experience to read about dangerous punctuation. Informative for everyone looking on the subject.

June 15, 2017 at 4:38 AM  
Blogger Mitch Hort said...

Finding a reputable payday loan company is important if, you find that you need to take out a payday loan. Check their reputation on the Better Business Bureau website, to see if they are rated well. When applying to an online company, make sure they use secure encryption technology to transfer your information.

prestamos economicos

July 6, 2017 at 5:06 AM  
Blogger ALINAAMEL said...

October 12, 2017 at 2:23 AM  
Blogger annika romy said...

The website is looking bit flashy and it catches the visitors eyes. A design is pretty simple .
office 2010 professional plus key deutsch

November 6, 2017 at 9:00 PM  
Blogger ALINAAMEL said...

Interesting post! This is really helpful for me. I like it! Thanks for sharing!
WebDesign Lüdenscheid

December 14, 2017 at 11:05 PM  

Post a Comment

Subscribe to Post Comments [Atom]

<< Home