[GNC] Small business accounting importing transactions

[rwslippey]

Thanks Stephen,

I like the database way of going about this... it's detailed. Fortunately, I
don't have a requirement for the taxes and shipping info, these are simply
invoices for my service business, so that makes life a little easier. 

I didn't consider that multiple deposits in one day might be a problem so
I'm glad you mentioned that.

thanks 

rob


Stephen M. Butler wrote
> Rob,
> 
> I have a small Squarespace business that uses Stripe for processing the
> CC payments.  I have automated the download of the orders and load those
> up into a SQLite3 database so I know the tax and shipping charges per
> order.  I manually download the payments from Stripe to add in the
> processing fees.  Several payments may be on each daily deposit (if I
> were only that lucky to have daily orders).  I record in GnC the
> following:
> 
> Asset:Bank:Checking  -- Net amount deposited (Debit)
> Expense:Fees:Stripe -- Total Processing fees Stripe chaged for all sales
> that deposit (Debit)
> Expense:Cost-of-Goods-Sold -- My total cost of items sold (see Inventory
> side)  (Debit)
> Income:Sales -- Gross sold amount (not including shipping and taxes) 
> (Credit)
> Income:Shipping -- Amount collected for Shipping/Handling (Credit)
> Liability:State Sales Tax  -- State portion of sales taxes collected
> (Credit)
> Liability:Local Sales Tax -- Local portion of sales taxes collected
> (Credit)
> Asset:Inventory -- COGS to deduct from Inventory (Credit)
> 
> Note that this is per Stripe deposit and not per order.  Several orders
> may be summed up for each deposit.  I thought of summing up the entire
> week into one entry but that would get messy when the bank issues a
> statement mid-week.
> 
> I wrote a sql statement to get all of these numbers from the database. 
> I manually enter these into GnC.  You could dump the output as a CSV and
> import it into GnC to further automate it.  When I get to several orders
> each day, then I'll make that effort (including the automatic download
> of the payment file from Stripe).
> 
> -- 
> Stephen M Butler, PMP, PSM

> Stephen.M.Butler51@

> 

> kg7je@

> 253-350-0166





--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html