Excel Accounting Template is the easiest workflow for the novice accountant. Ideal for new entrepreneurs just getting started and not wanting or needing a balance sheet. This is not ideal for corporations but small businesses and sole proprietorships. Simply sit down with your bank statements and credit card statements and enter the information. The training video allows you to stop and go over the training multiple times at your convenience. The template has easy dropdowns for the categorization and the applicable taxes. It has the functionality to convert USD transactions with an updated converter. Every single province’s tax is available in the dropdown. There is no reporting or reconciliation function. Here’s the link for the Amazon Seller’s Accounting Template:
https://www.thesellersacademy.com/sales-page21659879
Quickbooks Pro (Subscription version) is a renown accounting software. It offers exceptional reporting allowing easy customization, memorization of transaction rules and advanced search functionality. For example, create custom profit and loss comparison reports showing the change in percentage and dollar amount. Select last year and current year and this report will show you the comparison without having to set all the parameters each time. In terms of transaction memorization, select a common expense such as rent from a certain vendor. Select that it is always categorized as Rent Expense and has applicable HST. From then on this item will appear with the Rent Expense categorization and applicable HST. Lastly, search any number in the search box. Quickbooks will find the amount in banking or journal entry references or wherever. I use this a ton as I jump around doing a multitude of things. Here’s the link for quickbooks: https://refer.quickbooks.ca/s/Rob015
Excel Accounting Template | Quickbooks | |
Cost | $249 one time fee | $20-$50/mth |
Ease of Use | Easy for new non-accounting people. Revenue section pulls information directly from reports available in amazon. | Easiest if medium to high understanding of accounting. Able to book journal entries is key. |
Stability | Some instability | Robust |
Reporting | Light reporting, Graphs & dashboard | Robust reporting |
Features | Step by step video training. Limited Accounting knowledge required and pre-populated dropdowns and multi-currency calculations. Converts USD transactions. | Transaction Memorization, Customization of Invoicing & Advanced search features. Multicurrency availability. Reconciliation tool. |
Main Pros | Ease of use of simple tracking, helpful dropdowns for taxes and categories. | Transaction memorization, Search functionality, Reporting. |
Main Cons | Lack of reporting and automation. | Cost can be prohibitive especially with multiple entities. |