This post is to review some amazing tools that can help any small business as they get started. (Or enhance common existing systems for larger businesses) This system is the most flexible, yet powerful set of tools that I have found for my business. (many other business owners agree, at least on the main component) This tool can be kept simple, but as you learn more and more about these tools, you can automate the process. (Auto import of transactions, automated math, and more.) Another important detail about this system is that it can integrate with programs like QuickBooks, and others, later when your company grows.
GOOGLE SHEETS – Is Google’s version of Excel. It’s a spreadsheet program that has cloud sync and a ridiculous amount of possible integrations if you desire. It’s always backed up and encrypted by Google. You can access it on any major platform or device. You can just use it as a digital ledger or you can add formulas to turn it into your own no-code custom business program. You can use it to track inventory, materials, costs, revenue, profit, etc. Pretty much anything you want to track. Furthermore, you can make each of the spreadsheets talk to each other. (both with other tabs & with entirely separate spreadsheets) This program also allows you to connect spreadsheets to your sales/invoice system. (Such as Square, PayPal, and Etsy for smaller businesses) (Tutorial on How to Use Google Sheets – Click Here) It’s free for your personal account, then later when you decide to get a business account, the prices are reasonable.
INTEGROMAT – Is an automation and integrations system (like IFTTT) that focuses on businesses. It allows you to connect services from different companies, so you can create a seamless integrated system, even when you are cherry-picking the right services for your situation. Using this service, you can connect your PayPal, Square, Etsy, and other services to, say, Google Sheets. When used in combination, this service can automatically update a google spreadsheet with your sales/transactions without any data entry on your part. Then, if you setup the google sheet correctly, google sheets can automatically do all the calculations and update your inventory. This service starts free, but can grow with your business and at reasonable prices. It’s not one of those Free services that gouges you after you’ve gotten used to their services.
Integration here is the key to this systems power, but when you grow, you’ll probably want something more substantial that can track the extra complexities that come with a growing business and to automate taxes and so on. These tools can integrate with those systems, such as QuickBooks, SalesForce, and hundreds of others so you don’t have to worry about losing the tools you’ve spent time creating.
Note – For those that want to take this system even farther (a more advanced feature) it is possible to place images over a spreadsheet (background must be transparent, which is easy to accomplish with the free program GIMP, using the select color and erase tools.) Then you can align cells with the areas you need to fill in and use formulas that talk to the rest of your spreadsheets to automatically update your form. When business tax returns come around, such a tool makes filing a hundred times easier. Copy&Paste instead of Hunt&Calculate.
