Ocrolus cash flow analytics guide.xlsx

	A	B	C	D
1	Tag name	Description	Format	Category

2	tolls	Tolls during driving	boolean	Auto
3	truck_stop	Transaction at truck stop areas	boolean	Auto
4	atm	Transaction at phyiscal ATM locations	boolean	Cash
5	debt_consolidator	Transaction associated with debt refinancing and consolidation companies	boolean	Debt
6	factoring	Transaction associated with factoring companies	boolean	Debt
7	fintech	Transaction associated with a fintech company	boolean	Debt
8	fintech_loan	Loan transaction with a fintech company	boolean	Debt
9	bank_loan	Loan transaction with a traditional bank	boolean	Debt
10	other_loan	Loan transaction that does not fit into fintech_loan or bank_loan	boolean	Debt
11	fintech_mca	Merchant cash advance txn with a fintech company	boolean	Debt
12	bank_cash_advance	Cash advance with traditional bank	boolean	Debt
13	sba	Transaction associated with the Small Business Administration	boolean	Debt
14	credit_builder	Transaction with credit builder companies	boolean	Debt
15	withdrawals	Amount less than 0	boolean	Deposits/Withdrawals
16	deposits	Amount greater than 0	boolean	Deposits/Withdrawals
17	outside_source_deposits	Deposits that are not internal_transfer or other_transfer	boolean	Deposits/Withdrawals
18	probable_recurring_txns	Transactions with 2 or more similar occurences	boolean	Deposits/Withdrawals
19	expense	Withdrawals that have been included as expense	boolean	Expense
20	crypto	Transaction associated with cryptocurrency and related companies	boolean	Investing
21	investment	Transaction associated with investment and brokerage companies	boolean	Investing
22	nsf	Fees associated with non-sufficient funds events	boolean	NSF/Overdraft
23	overdraft	Fees associated with overdraft events	boolean	NSF/Overdraft
24	returned_item	Items that were returned due to a non-sufficient funds event	boolean	NSF/Overdraft
25	insurance	Transaction associated with insurance premiums or payouts	boolean	Other
26	equipment_lease	Transaction associated with equipment leasing companies	boolean	Other
27	txn_four_zeros	Amount is multiple of $100.00	boolean	Other
28	txn_five_zeros	Amount is multiple of $1000.00	boolean	Other
29	bank	Transaction associated with a traditional bank/depository institution	boolean	Other
30	benefits	Transaction associated with government benefits	boolean	Other
31	card_rewards	Transaction associated with credit card rewards	boolean	Other
32	gambling	Transaction associated with gambling (ex: casino and lottery)	boolean	Other
33	revenue_deduction_other	Transaction that has been removed from revenue but does not fit into other categories	boolean	Other
34	reversed	Transaction that has been reversed	boolean	Other
35	bank_branch	Transaction with a physical bank branch	boolean	Other
36	revenue_deduction	Deposits that have not been included in revenue	boolean	Other
37	venmo_zelle_cashapp	Transaction with Venmo, Zelle, or Cash App	boolean	Payment Processing
38	paypal	Transaction with paypal	boolean	Payment Processing
39	checks	Transaction with a check (physical or electronic)	boolean	Payment Processing
40	debit_card	Debit card transaction	boolean	Payment Processing
41	credit_card	Credit card transaction	boolean	Payment Processing
42	merchant_service	Transaction associated with payment processing companies	boolean	Payment Processing
43	remote	Remote or mobile transactions	boolean	Payment Processing
44	payroll	Transaction associated with payroll activities and companies	boolean	Payroll
45	revenue	Deposits that have been included in revenue	boolean	Revenue
46	state_tax	State tax transaction	boolean	Tax
47	payroll_tax	Payroll tax ransaction	boolean	Tax
48	federal_tax	Federal tax transaction	boolean	Tax
49	internal_transfer	Transfer between accounts with the same owner	boolean	Transfer
50	merchant_service_transfer	Transfer to/from a merchant service company	boolean	Transfer
51	wire_transfer	Wire transfer	boolean	Transfer
52	other_transfer	Transfer that does not fit into other categories	boolean	Transfer
53	fintech_loan_source	Clean name of fintech loan provider (if applicable)	string	Debt
54	fintech_mca_source	Clean name of fintech MCA provider (if applicable)	string	Debt
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