I have a small solo business where I sell services on a website. I probably have about 100 small transactions per month and people pay me with PayPal or Stripe.
I have been doing accounting in an Excel spreadsheet, where each month I export all of the transactions from PayPal and Stripe, add some other expenses, and add some formulas to add up relevant numbers. It works, but I'd like something more automated.
I've been checking out online accounting tools (Wave, Quickbooks, etc.). Some of them have some functionality for automatic import of PayPal/Stripe transactions, but it is complicated and time consuming to set up and then I find out it doesn't do something I need.
Instead of doing automatic import of PayPal/Stripe transactions, I was thinking of doing it manually and just adding 6 monthly entries for total sales, fees, and transfers for each of PayPal and Stripe for the entire month.
For example, with Wave, it syncs with my business bank account so transfers from PayPal/Stripe will show up there. I'll then add just 6 manual entries per month and reconciling seems straightforward.
Is this a good solution or are there pitfalls that I need to be aware of? Thanks for your help.