[Boards: 3 / a / aco / adv / an / asp / b / biz / c / cgl / ck / cm / co / d / diy / e / fa / fit / g / gd / gif / h / hc / his / hm / hr / i / ic / int / jp / k / lgbt / lit / m / mlp / mu / n / news / o / out / p / po / pol / qa / r / r9k / s / s4s / sci / soc / sp / t / tg / toy / trash / trv / tv / u / v / vg / vp / vr / w / wg / wsg / wsr / x / y ] [Home]
4chanarchives logo
As a new small business owner, what should I know about tracking
Images are sometimes not shown due to bandwidth/network limitations. Refreshing the page usually helps.

You are currently reading a thread in /biz/ - Business & Finance

Thread replies: 8
Thread images: 1
File: imgres.jpg (12 KB, 353x143) Image search: [Google]
imgres.jpg
12 KB, 353x143
I am using Google sheets to track ins and outs of money in my business. But what should I definitely do, and not do?

Thanks!
>>
No one does their taxes here? I'll just call the IRS.....
>>
don't look for business advice on website with pictures of cocks on them.
>>
>>1044424
OK, serious answer here.

I'm a programmer and I sell products.

You want to keep a table for inventory and sales at the very least. Each table breaks down the respective transactions into their smallest components. For example, I track item price, tax, fees, insurance, shipping vouchers, shipping cost, refunds, etc. Then at the end of the year (or tax period), all you really have to do is sum up some rows/columns.

Now I over complicated this and did it in SQL Server with some fancy calculations to calculate item cost on the fly to determine a gain/loss on every sale and print out price sheets and a ton of other things. But you can still do the core functionality (how much did I make this year, how much tax do I owe, etc) with Excel or another spreadsheet.

You definitely want to keep a box with all of your receipts and invoices. And you definitely want to keep a backup of your spreadsheet on CD/SSD/paper or something. Just in case because the IRS can audit you a few years back. May be naive here but I expect an audit isn't such a horror story for people that A) aren't immediately hostile towards government and B) are organized enough to prove profits/losses.
>>
You should definitely not own your own business if you don't know anything about business.
>>
>>1044462
Thanks for your advice, it is great.

Can I use Wave accounting for all of this, and not have to worry about using excel at all?
>>
>>1044498
I'm not familiar with Wave. You can use any spreadsheet program though. Excel, Lotus, OO Calc, Google Sheets, etc. Or notebook paper if you have the time to do the calculations yourself.
>>
>>1044462
>SQL
>Complicated

Will someone just develop an open source ERP already? Hint hint code monkey.
Thread replies: 8
Thread images: 1

banner
banner
[Boards: 3 / a / aco / adv / an / asp / b / biz / c / cgl / ck / cm / co / d / diy / e / fa / fit / g / gd / gif / h / hc / his / hm / hr / i / ic / int / jp / k / lgbt / lit / m / mlp / mu / n / news / o / out / p / po / pol / qa / r / r9k / s / s4s / sci / soc / sp / t / tg / toy / trash / trv / tv / u / v / vg / vp / vr / w / wg / wsg / wsr / x / y] [Home]

All trademarks and copyrights on this page are owned by their respective parties. Images uploaded are the responsibility of the Poster. Comments are owned by the Poster.
If a post contains personal/copyrighted/illegal content you can contact me at [email protected] with that post and thread number and it will be removed as soon as possible.
DMCA Content Takedown via dmca.com
All images are hosted on imgur.com, send takedown notices to them.
This is a 4chan archive - all of the content originated from them. If you need IP information for a Poster - you need to contact them. This website shows only archived content.