Stora Accounting Template.xlsx

	A	B	E	F	G	H	I
1	Stripe Journal 1				Version 3.03
2	Using the Debits and credits summary report data from Stripe
3
4	Journal Period	Dec-21	(must be nil)		0.00
5	Journal Date	23/01/2022
6
7	STRIPE Chart of Accounts	Type	Journal Debit	Journal Credit	Journal code	Account description	Stripe definition

8	AccountsReceivable	B/S	1,104.30	-		Debtors Manual control (see accounts aging report)	AccountsReceivable represents the amount you bill to customers and may be inclusive of taxes and other amounts that aren't included in recognizable revenue. This account increases when invoices are finalized and decreases when invoices are paid. The ending balance reflects the amount due from customers at the end of each month.
9	BadDebt	P&L	-	-		Bad debt expense (P&L)	Previously recognized revenue from invoices that have been marked as uncollectible.
10	Cash	B/S	13,944.04	-		Stripe debtor control account	Cash is the net cash amount received. This doesn't include Stripe fees or payouts. It's calculated by subtracting refunds, disputes, and dispute reversals from your Stripe Balance Net Charge amount. Cash increases when customers pay their outstanding invoice balance. This also results in a corresponding decrease in AccountsReceivable.
11	CreditNotes	P&L	-	-		Revenue (P&L)	Portion of the credit note amount previously recognized. For example, if there's a 120 USD credit note on an annual subscription during the second month, 20 USD for the first 2 months is contra revenue. The remaining 100 USD is adjusted and reflected in your deferred revenue balance in the balance sheet.
12	CustomerBalance	B/S	10.44	-		Customer Balance (manual creditor)	Credits that your customers accrue. The ending balance reflects the amount of invoices that were paid using customer credit balance. This reduces AccountsReceivable.
13	CustomerBalanceAdjustments	P&L	-	-		Stripe Customer Balance Adjustments P&L	Expenses incurred due to manual adjustments to a customer credit balance.
14	DeferredRevenue	B/S	-	129.53		Deferred Revenue	Services that have been invoiced but not yet recognized as revenue. This represents a liability on your balance sheet because you have received cash for services that your business must deliver in future periods. The month end balance reflects the amount expected to be recognized in future periods.
15	Disputes	P&L	-	-		Revenue (P&L)	Portion of the disputed amount previously recognized. For example, if there's a 120 USD dispute on an annual subscription during the second month, 20 USD for the first 2 months is contra revenue. The remaining 100 USD is adjusted and reflected in your deferred revenue balance in the balance sheet.
16	ExternalAsset	B/S	-	-		Manual Payments Debtor control	Invoices you manually mark as paid when you receive funds outside of Stripe. The ending balance reflects the amount of invoices that were marked as paid using the Stripe Dashboard. This reduces AccountsReceivable.
17	FxLoss	P&L	-	-		Foreign Exchange Gains / Losses P&L	Total loss due to foreign currency exchange rates.
18	PendingCash	B/S	-	-		Pending cash control account (Manual Debtor account)	Cash from payments that haven't been confirmed. It can take several days to confirm whether a payment is successful. When the amount is confirmed, it's transferred to the Cash account. This happens with asynchronous payment methods like ACH debit.
19	Recoverables	P&L	-	-		Other Income	Recovered funds that aren't attributable to revenue. For example, if you have a 120 USD dispute on an annual subscription during the second month, 20 USD for the first 2 months is contra revenue and the remaining 100 USD is adjusted from the deferred revenue balance. If you win the dispute and 120 USD is returned to you, 20 USD is reflected as revenue and the remaining 100 USD is reflected as recoverables.
20	Refunds	P&L	42.15	-		Revenue (P&L)	Portion of the refunded amount previously recognized. For example, if you issue a 120 USD refund on an annual subscription during the second month, 20 USD for the first 2 months is contra revenue. The remaining 100 USD is adjusted and reflected in your deferred revenue balance in the balance sheet.
21	Revenue	P&L	-	12,569.62	see below for posting split	Revenue (P&L)	Recognizable portion of finalized invoices, prorated invoice items, and metered billing that count towards revenue during the month. For example, if an invoice line item is for 90 USD with 10 USD in taxes, the total invoice is 100 USD, but the recognizable portion is only 90 USD.
22	TaxLiability	B/S	-	2,401.78	see below for posting split	VAT	The tax component of issued invoices. The ending balance represents the tax amount invoiced to customers but is still owed to relevant tax authorities.
23	UnbilledAccountsReceivable	B/S	-	-		UnbilledAccountsReceivable - (manual debtor account)	Transactions (such as prorations due to upgrades or downgrades) that have service periods that start before an invoice is issued. The ending balance reflects the transactions that have accrued revenue but haven't been invoiced yet.
24	UnbilledVoids	P&L	-	-		Revenue (P&L)	Previously recognized revenue from prorated invoice items that have been deleted. These items are sometimes deleted when they generate unbilled accounts receivable and revenue.
25	Underpayments	P&L	-	-		Stripe underpayment Fees P&L	Expenses incurred due to underpayment from push payment methods.
26	Voids	P&L	-	-		Revenue (P&L)	Previously recognized revenue from invoices that have been voided.
27	TOTAL		15,100.93	15,100.93
28
29	Revenue and Tax Liability Split for Journal 1
30	Stnadard VAT rate	20%
31	zero-rated / exempt sales		- (560.72)			Income	Journal as a sale with zero / Exempt VAT
32	standard-rated sales		- (12,008.90)			Income	Journal as a sale with VAT at 20% (=2401.78) - @2
33	Total Income		- (12,569.62)
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100