QuickBooks Desktop Custom Reports Matrix by Hector@GarciaCPA.com - Last Update 01/03/2023

	A	B	C	D	E	F	G	H	I	J
1			Custom Summary Report			Transaction Detail Report			Questions/Sugestions: HECTOR@GARCIACPA.COM
2	orig. order	DATA FIELD	Row	Column	Filter	Field (Sortable)	Total by	Filter	Filter Type & Options	Hector's Notes

3	1	Customer:Job	x	x			x		** See NAME Filter	Classes are not collapasable in QB 2020
4	2	Customer Type	x	x	x		x	x	Drop-Down (Multiple Allowed)
5	3	Vendor	x	x			x		** See NAME Filter
6	4	Vendor Type	x	x	x		x	x	Drop-Down (Multiple Allowed)
7	5	Payee (or Source Name)	x	x		x	x		** See NAME Filter
8	6	Name			x			x	Drop-Down: Customers, Vendors, Employees, Other (Multiple Allowed)
9	7	Employee	x	x			x		** See NAME Filter
10	8	Other Name							** See NAME Filter
11	9	Item (or Item Detail)	x	x	x	x	x	x	Drop-Down: Service, Inventory, parts, assembly, payments, sales tax, and individual (Multiple Allowed)
12	10	Item Type	x	x			x
13	11	Inventory Site	x	x	x	x		x	Drop-Down (Multiple Allowed)	QBES Platinum Only
14	12	Account	x	x	x	x	x	x	Drop-Down (Multiple Allowed)
15	13	Rep	x	x		x	x	x	Drop-Down (Multiple Allowed)
16	14	Class	x	x	x	x	x	x	Drop-Down (Multiple Allowed)	Classes are not collapasable in QB 2020
17	15	Ship Via (or Via)	x	x		x	x	x	Drop-Down (Multiple Allowed)
18	16	Terms	x	x		x	x	x	Drop-Down (Multiple Allowed)
19	17	Payment Method	x	x	x	x	x	x	Drop-Down (Multiple Allowed)
20	18	Sales Tax Code	x	x	x	x	x	x	Drop-Down (Multiple Allowed)
21	19	Payroll Item	x	x	x	x	x	x	Drop-Down (Multiple Allowed)	Payroll Related
22	20	Day		x			x		** See DATE filter	Based on Transaction Date (Accrual) or modified to payment date for Invoices/Bills (cash basis)
23	21	Week		x			x		** See DATE filter	"
24	22	Two Week		x			x		** See DATE filter	"
25	23	Four Week		x			x		** See DATE filter	"
26	24	Half Month		x			x		** See DATE filter	"
27	25	Month		x			x		** See DATE filter	"
28	26	Quarter		x			x		** See DATE filter	"
29	27	Year		x			x		** See DATE filter	"
30	28	Balance Sheet	x	x			x
31	29	Summary Balance	x	x			x
32	30	Income Statement	x	x			x
33	31	Tax Line	x			x	x
34	32	Aging (Number of Days)			x	x		x	Amount: Any, Equals, More Than, Less Than	Affected by ADVANCED FILTER
35	33	Amount (line/transaction)			x	x		x	Amount: Any, Equals, More Than, Less Than. In Between
36	34	Billing Status			x	x		x	Choose: Any, Not Billable, Unbillable, Billed
37	35	Cleared (Clr)			x			x	Choose: Any, Cleared (Reconciled), Not Cleared
38	36	Date			x	x		x	Drop-Down Calendar
39	37	Detail Level			x			x	Choice: All, Summary Only, All except Summary
40	38	Due Date			x	x		x	Drop-Down Calendar
41	39	Entered/Last Modified Date			x	x		x	Drop-Down Calendar
42	40	Estimate Active			x	x		x	Choose: Either, No, Yes
43	41	FOB			x	x		x	Free Text
44	42	Is Adjustment (Adj)			x	x		x	Choose: Either, No, Yes
45	43	Job Status			x			x	Choice: All, None, Pending, Awarded, In Progress, Closed, Not Awarded
46	44	Job Type			x			x	Drop Down
47	45	Memo			x			x	Free Text
48	46	Name Note & Acct. Number			x	x		x	Free Text
49	47	Name Address			x	x		x	Free Text
50	48	Name City			x	x		x	Free Text
51	49	Name E-mail			x	x		x	Free Text
52	50	Name Fax Number			x	x		x	Free Text
53	51	Name Phone Number			x	x		x	Free Text
54	52	Name State			x	x		x	Free Text
55	53	Name Street1			x	x		x	Free Text
56	54	Name Street2			x	x		x	Free Text
57	55	Name Zip			x	x		x	Free Text
58	56	Name Contact				x
59	57	Number			x	x		x	Number or Range
60	58	Online Status			x			x	Choice: All, Online to send, Online Sent, Any Online Not Online	Bank Feeds Direct Connect only
61	59	Other 1			x	x		x	Free Text	Estimates, Sales Orders, Invoices, Sales Receipts, and Purchase Orders only
62	60	Other 2			x	x		x	Free Text	Estimates, Sales Orders, Invoices, Sales Receipts, and Purchase Orders only
63	61	P.O. Number			x			x	Free Text	Estimates, Sales Orders, Invoices, and Sales Receipts only
64	62	Paid Status			x	x		x	Choice: Either, Closed, Open	Accrual Reports Only
65	63	Paid Through			x	x		x	Drop-Down Calendar	Payroll Related
66	64	Pay Period Begin Date			x	x		x	Drop-Down Calendar	Payroll Related
67	65	Pay Period End Date			x	x		x	Drop-Down Calendar	Payroll Related
68	66	Payroll ytd detail	x	x			x
69	67	Posting Status			x			x	Choice: Either Posting, Non-posting
70	68	Preferred Delivery Method			x	x		x	Choice: All, E-mail, None, Mail
71	69	Preferred Vendor			x			x	Drop-Down (Multiple Allowed)	Only for item-based transactions
72	70	Printed Status			x	x		x	Choice: Either, Printed, To be Printed
73	71	Received			x			x	Choice: Either, Yes, No	Purchase Orders Only
74	72	Serial Number			x	x		x	Choice: Any, No Blanks, Blanks Only, Contains ____	QBES Platinum Only
75	73	Ship Date			x	x		x	Drop-Down Calendar	Sales forms only
76	74	Template			x			x	Drop-Down (Multiple Allowed)
77	75	Transaction Type			x	x		x	Drop-Down (Multiple Allowed)
78	76	Voided			x			x	Choice: Either, No, Yes
79	77	Worker's Comp Code			x		x	x	Drop-Down (Multiple Allowed)	Payroll Related
80	78	Zero QOH			x			x	Checkmark: Hide zero qty on hand?
81	79	Zero Reorder Qty			x			x	Checkmark: Hide zero reorder qty?
82	80	Downloaded Payments					x
83	81	Trans #				x
84	82	Deliv Date				x
85	83	Billed Date				x
86	83	SSN/Tax ID				x				Vendors
87	84	Item Description				x
88	85	Income Subject to Tax				x				Payroll Related
89	86	Wage Base				x				Payroll Related
90	87	Wage Base (tips)				x				Payroll Related
91	88	Split				x
92	89	Open Balance				x				Affected by ADVANCED FILTER
93	90	Qty				x
94	91	U/M				x				Unit of Measure
95	92	Sales price				x
96	93	Debit				x
97	94	Credit				x
98	95	Balance				x
99	96	Tax Table Version				x				Payroll Related
100	97	User Edit?				x