Audit Solution in R
Case Study: Analysis of Sales/AR
Stewart Li (MCom, Bsc, CA, ACCA)
15 April 2019
Read dataset
| debit | credit |
|---|---|
| 2136029 | 2136029 |
Review accounts
Daily sales movement for the period.
Review JV
Review double entires, such as dr: AR, cr: sales, and dr: cash, cr: AR.
| name | subaccount | type | debit | credit |
|---|---|---|---|---|
| Baker’s Professional Lighting:Store #05 | Accounts Receivable | Invoice | 2391.00 | 0.00 |
| Baker’s Professional Lighting:Store #05 | Accounts Receivable | Payment | 0.00 | 2391.00 |
| Baker’s Professional Lighting:Store #05 | Revenue | Invoice | 0.00 | 2391.00 |
| Baker’s Professional Lighting:Store #10 | Accounts Receivable | Invoice | 12718.48 | 0.00 |
| Baker’s Professional Lighting:Store #10 | Accounts Receivable | Payment | 0.00 | 2038.00 |
| Baker’s Professional Lighting:Store #10 | Revenue | Invoice | 0.00 | 12718.48 |
| Baker’s Professional Lighting:Store #15 | Accounts Receivable | Invoice | 3307.00 | 0.00 |
| Baker’s Professional Lighting:Store #15 | Accounts Receivable | Payment | 0.00 | 1885.00 |
| Baker’s Professional Lighting:Store #15 | Revenue | Invoice | 0.00 | 3307.00 |
| Baker’s Professional Lighting:Store #20 | Accounts Receivable | Invoice | 1872.00 | 0.00 |
| Baker’s Professional Lighting:Store #20 | Accounts Receivable | Payment | 0.00 | 1872.00 |
| Baker’s Professional Lighting:Store #20 | Revenue | Invoice | 0.00 | 1872.00 |
| Baker’s Professional Lighting:Store #25 | Accounts Receivable | Invoice | 2381.00 | 0.00 |
| Baker’s Professional Lighting:Store #25 | Accounts Receivable | Payment | 0.00 | 2381.00 |
| Baker’s Professional Lighting:Store #25 | Revenue | Invoice | 0.00 | 2381.00 |
| Cole Home Builders:Phase 1 - Lot 2 | Accounts Receivable | Invoice | 2187.45 | 0.00 |
| Cole Home Builders:Phase 1 - Lot 2 | Accounts Receivable | Payment | 0.00 | 2187.45 |
| Cole Home Builders:Phase 1 - Lot 2 | Revenue | Invoice | 0.00 | 2187.45 |
| Cole Home Builders:Phase 1 - Lot 4 | Accounts Receivable | Invoice | 2187.45 | 0.00 |
| Cole Home Builders:Phase 1 - Lot 4 | Accounts Receivable | Payment | 0.00 | 2187.45 |
| Cole Home Builders:Phase 1 - Lot 4 | Revenue | Invoice | 0.00 | 2187.45 |
| Cole Home Builders:Phase 1 - Lot 5 | Accounts Receivable | Invoice | 25876.80 | 0.00 |
| Cole Home Builders:Phase 1 - Lot 5 | Accounts Receivable | Payment | 0.00 | 25876.80 |
| Cole Home Builders:Phase 1 - Lot 5 | Revenue | Invoice | 0.00 | 25876.80 |
| Cole Home Builders:Phase 2 - Lot 5 | Accounts Receivable | Invoice | 13973.30 | 0.00 |
| Cole Home Builders:Phase 2 - Lot 5 | Accounts Receivable | Payment | 0.00 | 13973.30 |
| Cole Home Builders:Phase 2 - Lot 5 | Revenue | Invoice | 0.00 | 13973.30 |
| Dan A. North Builders:Custom Order - Suite 100A | Accounts Receivable | Invoice | 3500.00 | 0.00 |
| Dan A. North Builders:Custom Order - Suite 100A | Revenue | Invoice | 0.00 | 7000.00 |
| Dan A. North Builders:McCarthy Properties | Accounts Receivable | Invoice | 8929.00 | 0.00 |
| Dan A. North Builders:McCarthy Properties | Accounts Receivable | Payment | 0.00 | 8929.00 |
| Dan A. North Builders:McCarthy Properties | Revenue | Invoice | 0.00 | 8929.00 |
| Dan A. North Builders:Turner Suites | Accounts Receivable | Invoice | 13300.00 | 0.00 |
| Dan A. North Builders:Turner Suites | Accounts Receivable | Payment | 0.00 | 13300.00 |
| Dan A. North Builders:Turner Suites | Revenue | Invoice | 0.00 | 13300.00 |
| Dan A. North Builders:Wagner Suites | Accounts Receivable | Invoice | 7890.00 | 0.00 |
| Dan A. North Builders:Wagner Suites | Accounts Receivable | Payment | 0.00 | 7890.00 |
| Dan A. North Builders:Wagner Suites | Revenue | Invoice | 0.00 | 7890.00 |
| Godwin Lighting Depot:Store #1020 | Accounts Receivable | Invoice | 2578.95 | 0.00 |
| Godwin Lighting Depot:Store #1020 | Accounts Receivable | Payment | 0.00 | 2578.95 |
| Godwin Lighting Depot:Store #1020 | Revenue | Invoice | 0.00 | 2578.95 |
| Godwin Lighting Depot:Store #202 | Accounts Receivable | Invoice | 9474.35 | 0.00 |
| Godwin Lighting Depot:Store #202 | Accounts Receivable | Payment | 0.00 | 9474.35 |
| Godwin Lighting Depot:Store #202 | Revenue | Invoice | 0.00 | 9474.35 |
| Godwin Lighting Depot:Store #303 | Accounts Receivable | Invoice | 6845.85 | 0.00 |
| Godwin Lighting Depot:Store #303 | Accounts Receivable | Payment | 0.00 | 6845.85 |
| Godwin Lighting Depot:Store #303 | Revenue | Invoice | 0.00 | 6845.85 |
| Godwin Lighting Depot:Store #404 | Accounts Receivable | Invoice | 7642.80 | 0.00 |
| Godwin Lighting Depot:Store #404 | Accounts Receivable | Payment | 0.00 | 7642.80 |
| Godwin Lighting Depot:Store #404 | Revenue | Invoice | 0.00 | 7642.80 |
| Godwin Lighting Depot:Store #909 | Accounts Receivable | Invoice | 5157.90 | 0.00 |
| Godwin Lighting Depot:Store #909 | Accounts Receivable | Payment | 0.00 | 5157.90 |
| Godwin Lighting Depot:Store #909 | Revenue | Invoice | 0.00 | 5157.90 |
| Kern Lighting Warehouse:Store #01 | Accounts Receivable | Invoice | 34929.00 | 0.00 |
| Kern Lighting Warehouse:Store #01 | Accounts Receivable | Payment | 0.00 | 34929.00 |
| Kern Lighting Warehouse:Store #01 | Revenue | Invoice | 0.00 | 34929.00 |
| Kern Lighting Warehouse:Store #13 | Accounts Receivable | Invoice | 37725.00 | 0.00 |
| Kern Lighting Warehouse:Store #13 | Accounts Receivable | Payment | 0.00 | 35502.50 |
| Kern Lighting Warehouse:Store #13 | Revenue | Invoice | 0.00 | 37725.00 |
| Kern Lighting Warehouse:Store #34 | Accounts Receivable | Invoice | 34624.60 | 0.00 |
| Kern Lighting Warehouse:Store #34 | Accounts Receivable | Payment | 0.00 | 34624.60 |
| Kern Lighting Warehouse:Store #34 | Revenue | Invoice | 0.00 | 34624.60 |
| Kern Lighting Warehouse:Store #45 | Accounts Receivable | Invoice | 30675.00 | 0.00 |
| Kern Lighting Warehouse:Store #45 | Accounts Receivable | Payment | 0.00 | 30675.00 |
| Kern Lighting Warehouse:Store #45 | Revenue | Invoice | 0.00 | 30675.00 |
| Lavery Lighting & Design:Store #JL-01 | Accounts Receivable | Invoice | 5279.00 | 0.00 |
| Lavery Lighting & Design:Store #JL-01 | Accounts Receivable | Payment | 0.00 | 5279.00 |
| Lavery Lighting & Design:Store #JL-01 | Revenue | Invoice | 0.00 | 5279.00 |
| Lavery Lighting & Design:Store #JL-04 | Accounts Receivable | Invoice | 11715.00 | 0.00 |
| Lavery Lighting & Design:Store #JL-04 | Accounts Receivable | Payment | 0.00 | 11715.00 |
| Lavery Lighting & Design:Store #JL-04 | Revenue | Invoice | 0.00 | 11715.00 |
| Lavery Lighting & Design:Store #JL-06 | Accounts Receivable | Invoice | 4694.50 | 0.00 |
| Lavery Lighting & Design:Store #JL-06 | Accounts Receivable | Payment | 0.00 | 4694.50 |
| Lavery Lighting & Design:Store #JL-06 | Revenue | Invoice | 0.00 | 4694.50 |
| Lavery Lighting & Design:Store #JL-08 | Accounts Receivable | Invoice | 3308.10 | 0.00 |
| Lavery Lighting & Design:Store #JL-08 | Accounts Receivable | Payment | 0.00 | 600.00 |
| Lavery Lighting & Design:Store #JL-08 | Revenue | Invoice | 0.00 | 3308.10 |
| Miscellaneous - Retail:Alison Johnson | Accounts Receivable | Invoice | 854.00 | 0.00 |
| Miscellaneous - Retail:Alison Johnson | Accounts Receivable | Payment | 0.00 | 854.00 |
| Miscellaneous - Retail:Alison Johnson | Revenue | Invoice | 0.00 | 854.00 |
| Miscellaneous - Retail:Anne Loomis | Accounts Receivable | Invoice | 1608.00 | 0.00 |
| Miscellaneous - Retail:Anne Loomis | Accounts Receivable | Payment | 0.00 | 1608.00 |
| Miscellaneous - Retail:Anne Loomis | Revenue | Invoice | 0.00 | 1608.00 |
| Miscellaneous - Retail:Brian Stern | Accounts Receivable | Invoice | 1126.00 | 0.00 |
| Miscellaneous - Retail:Brian Stern | Accounts Receivable | Payment | 0.00 | 1126.00 |
| Miscellaneous - Retail:Brian Stern | Revenue | Invoice | 0.00 | 1126.00 |
| Miscellaneous - Retail:Carlos Nazar | Accounts Receivable | Invoice | 2025.00 | 0.00 |
| Miscellaneous - Retail:Carlos Nazar | Accounts Receivable | Payment | 0.00 | 2025.00 |
| Miscellaneous - Retail:Carlos Nazar | Revenue | Invoice | 0.00 | 2025.00 |
| Miscellaneous - Retail:David Lo | Accounts Receivable | Invoice | 1932.00 | 0.00 |
| Miscellaneous - Retail:David Lo | Accounts Receivable | Payment | 0.00 | 1932.00 |
| Miscellaneous - Retail:David Lo | Revenue | Invoice | 0.00 | 1932.00 |
| Miscellaneous - Retail:Doug Jacobsen | Accounts Receivable | Invoice | 1719.00 | 0.00 |
| Miscellaneous - Retail:Doug Jacobsen | Accounts Receivable | Payment | 0.00 | 1719.00 |
| Miscellaneous - Retail:Doug Jacobsen | Revenue | Invoice | 0.00 | 1719.00 |
| Miscellaneous - Retail:Jann Minor | Accounts Receivable | Invoice | 2085.00 | 0.00 |
| Miscellaneous - Retail:Jann Minor | Accounts Receivable | Payment | 0.00 | 2085.00 |
| Miscellaneous - Retail:Jann Minor | Revenue | Invoice | 0.00 | 2085.00 |
| Miscellaneous - Retail:Jason Helper | Accounts Receivable | Invoice | 1812.00 | 0.00 |
| Miscellaneous - Retail:Jason Helper | Accounts Receivable | Payment | 0.00 | 1812.00 |
| Miscellaneous - Retail:Jason Helper | Revenue | Invoice | 0.00 | 1812.00 |
| Miscellaneous - Retail:John Huhn | Accounts Receivable | Invoice | 2239.00 | 0.00 |
| Miscellaneous - Retail:John Huhn | Accounts Receivable | Payment | 0.00 | 2239.00 |
| Miscellaneous - Retail:John Huhn | Revenue | Invoice | 0.00 | 2239.00 |
| Miscellaneous - Retail:Lara Gussman | Accounts Receivable | Invoice | 1679.00 | 0.00 |
| Miscellaneous - Retail:Lara Gussman | Accounts Receivable | Payment | 0.00 | 1679.00 |
| Miscellaneous - Retail:Lara Gussman | Revenue | Invoice | 0.00 | 1679.00 |
| Miscellaneous - Retail:Melanie Hall | Accounts Receivable | Invoice | 1600.00 | 0.00 |
| Miscellaneous - Retail:Melanie Hall | Accounts Receivable | Payment | 0.00 | 1600.00 |
| Miscellaneous - Retail:Melanie Hall | Revenue | Invoice | 0.00 | 1600.00 |
| Miscellaneous - Retail:Mr. Fred Kaseman | Accounts Receivable | Invoice | 2221.00 | 0.00 |
| Miscellaneous - Retail:Mr. Fred Kaseman | Accounts Receivable | Payment | 0.00 | 2221.00 |
| Miscellaneous - Retail:Mr. Fred Kaseman | Revenue | Invoice | 0.00 | 2221.00 |
| Miscellaneous - Retail:Mr. Jay Jessen | Accounts Receivable | Invoice | 1239.00 | 0.00 |
| Miscellaneous - Retail:Mr. Jay Jessen | Accounts Receivable | Payment | 0.00 | 1239.00 |
| Miscellaneous - Retail:Mr. Jay Jessen | Revenue | Invoice | 0.00 | 1239.00 |
| Miscellaneous - Retail:Mrs. Anne Hemp | Accounts Receivable | Invoice | 1563.00 | 0.00 |
| Miscellaneous - Retail:Mrs. Anne Hemp | Accounts Receivable | Payment | 0.00 | 1563.00 |
| Miscellaneous - Retail:Mrs. Anne Hemp | Revenue | Invoice | 0.00 | 1563.00 |
| Miscellaneous - Retail:Mrs. Chris Holly | Accounts Receivable | Invoice | 1300.00 | 0.00 |
| Miscellaneous - Retail:Mrs. Chris Holly | Accounts Receivable | Payment | 0.00 | 1300.00 |
| Miscellaneous - Retail:Mrs. Chris Holly | Revenue | Invoice | 0.00 | 1300.00 |
| Miscellaneous - Retail:Ms. Jann Minor | Accounts Receivable | Invoice | 1084.00 | 0.00 |
| Miscellaneous - Retail:Ms. Jann Minor | Accounts Receivable | Payment | 0.00 | 1084.00 |
| Miscellaneous - Retail:Ms. Jann Minor | Revenue | Invoice | 0.00 | 1084.00 |
| Miscellaneous - Retail:Peter Karpas | Accounts Receivable | Invoice | 1714.00 | 0.00 |
| Miscellaneous - Retail:Peter Karpas | Accounts Receivable | Payment | 0.00 | 1714.00 |
| Miscellaneous - Retail:Peter Karpas | Revenue | Invoice | 0.00 | 1714.00 |
| Miscellaneous - Retail:Ruth Kuver | Accounts Receivable | Invoice | 1366.00 | 0.00 |
| Miscellaneous - Retail:Ruth Kuver | Accounts Receivable | Payment | 0.00 | 1366.00 |
| Miscellaneous - Retail:Ruth Kuver | Revenue | Invoice | 0.00 | 1366.00 |
| Miscellaneous - Retail:Sean Martin | Accounts Receivable | Invoice | 1542.00 | 0.00 |
| Miscellaneous - Retail:Sean Martin | Accounts Receivable | Payment | 0.00 | 1542.00 |
| Miscellaneous - Retail:Sean Martin | Revenue | Invoice | 0.00 | 1542.00 |
| Miscellaneous - Retail:Valesha Jones | Accounts Receivable | Invoice | 2395.00 | 0.00 |
| Miscellaneous - Retail:Valesha Jones | Accounts Receivable | Payment | 0.00 | 2395.00 |
| Miscellaneous - Retail:Valesha Jones | Revenue | Invoice | 0.00 | 2395.00 |
| Stern Commercial Contractor’s:Tittle Properties | Accounts Receivable | Invoice | 17433.00 | 0.00 |
| Stern Commercial Contractor’s:Tittle Properties | Accounts Receivable | Payment | 0.00 | 17433.00 |
| Stern Commercial Contractor’s:Tittle Properties | Revenue | Invoice | 0.00 | 17433.00 |
| Stern Commercial Contractor’s:Walker Properties | Accounts Receivable | Invoice | 21330.00 | 0.00 |
| Stern Commercial Contractor’s:Walker Properties | Accounts Receivable | Payment | 0.00 | 21330.00 |
| Stern Commercial Contractor’s:Walker Properties | Revenue | Invoice | 0.00 | 21330.00 |
| Stern Commercial Contractor’s:Wilson Suites | Accounts Receivable | Invoice | 14355.00 | 0.00 |
| Stern Commercial Contractor’s:Wilson Suites | Accounts Receivable | Payment | 0.00 | 14355.00 |
| Stern Commercial Contractor’s:Wilson Suites | Revenue | Invoice | 0.00 | 14355.00 |
| Thompson Lighting Stores:Store #15 | Accounts Receivable | Invoice | 14825.00 | 0.00 |
| Thompson Lighting Stores:Store #15 | Accounts Receivable | Payment | 0.00 | 3025.00 |
| Thompson Lighting Stores:Store #15 | Revenue | Invoice | 0.00 | 14825.00 |
| Thompson Lighting Stores:Store #20 | Accounts Receivable | Invoice | 3025.00 | 0.00 |
| Thompson Lighting Stores:Store #20 | Accounts Receivable | Payment | 0.00 | 3025.00 |
| Thompson Lighting Stores:Store #20 | Revenue | Invoice | 0.00 | 3025.00 |
| Thompson Lighting Stores:Store #30 | Accounts Receivable | Invoice | 3025.00 | 0.00 |
| Thompson Lighting Stores:Store #30 | Accounts Receivable | Payment | 0.00 | 3025.00 |
| Thompson Lighting Stores:Store #30 | Revenue | Invoice | 0.00 | 3025.00 |
| Thompson Lighting Stores:Store #40 | Accounts Receivable | Invoice | 3025.00 | 0.00 |
| Thompson Lighting Stores:Store #40 | Accounts Receivable | Payment | 0.00 | 3025.00 |
| Thompson Lighting Stores:Store #40 | Revenue | Invoice | 0.00 | 3025.00 |
| Thompson Lighting Stores:Store #50 | Accounts Receivable | Invoice | 3025.00 | 0.00 |
| Thompson Lighting Stores:Store #50 | Accounts Receivable | Payment | 0.00 | 3025.00 |
| Thompson Lighting Stores:Store #50 | Revenue | Invoice | 0.00 | 3025.00 |
Ensure all sales are recorded. sFor instance, dr: AR, cr: sales.
| name | num | date | Accounts Receivable | Revenue |
|---|---|---|---|---|
| Baker’s Professional Lighting:Store #05 | 71110 | 2018-02-14 | 2391.00 | 2391.00 |
| Baker’s Professional Lighting:Store #10 | 71111 | 2018-05-09 | 2038.00 | 2038.00 |
| Baker’s Professional Lighting:Store #10 | 71138 | 2018-12-07 | 10680.48 | 10680.48 |
| Baker’s Professional Lighting:Store #15 | 71052 | 2018-02-27 | 1885.00 | 1885.00 |
| Baker’s Professional Lighting:Store #15 | 71135 | 2018-12-15 | 1422.00 | 1422.00 |
| Baker’s Professional Lighting:Store #20 | 71048 | 2018-03-11 | 1872.00 | 1872.00 |
| Baker’s Professional Lighting:Store #25 | 71047 | 2018-01-06 | 2381.00 | 2381.00 |
| Cole Home Builders:Phase 1 - Lot 2 | 71088 | 2018-02-12 | 2187.45 | 2187.45 |
| Cole Home Builders:Phase 1 - Lot 4 | 71086 | 2018-05-24 | 2187.45 | 2187.45 |
| Cole Home Builders:Phase 1 - Lot 5 | 71073 | 2018-08-31 | 2138.40 | 2138.40 |
| Cole Home Builders:Phase 1 - Lot 5 | 71074 | 2018-08-24 | 2138.40 | 2138.40 |
| Cole Home Builders:Phase 1 - Lot 5 | 71075 | 2018-08-17 | 2138.40 | 2138.40 |
| Cole Home Builders:Phase 1 - Lot 5 | 71076 | 2018-07-16 | 2138.40 | 2138.40 |
| Cole Home Builders:Phase 1 - Lot 5 | 71077 | 2018-07-31 | 2009.25 | 2009.25 |
| Cole Home Builders:Phase 1 - Lot 5 | 71078 | 2018-07-27 | 2009.25 | 2009.25 |
| Cole Home Builders:Phase 1 - Lot 5 | 71079 | 2018-07-12 | 2009.25 | 2009.25 |
| Cole Home Builders:Phase 1 - Lot 5 | 71080 | 2018-06-12 | 2009.25 | 2009.25 |
| Cole Home Builders:Phase 1 - Lot 5 | 71082 | 2018-06-15 | 1637.10 | 1637.10 |
| Cole Home Builders:Phase 1 - Lot 5 | 71084 | 2018-05-18 | 1637.10 | 1637.10 |
| Cole Home Builders:Phase 1 - Lot 5 | 71085 | 2018-06-07 | 2187.45 | 2187.45 |
| Cole Home Builders:Phase 1 - Lot 5 | 71087 | 2018-04-16 | 2187.45 | 2187.45 |
| Cole Home Builders:Phase 1 - Lot 5 | 71089 | 2018-07-05 | 1637.10 | 1637.10 |
| Cole Home Builders:Phase 2 - Lot 5 | 71051 | 2018-02-10 | 4364.00 | 4364.00 |
| Cole Home Builders:Phase 2 - Lot 5 | 71072 | 2018-01-28 | 2187.45 | 2187.45 |
| Cole Home Builders:Phase 2 - Lot 5 | 71081 | 2018-06-12 | 1637.10 | 1637.10 |
| Cole Home Builders:Phase 2 - Lot 5 | 71083 | 2018-05-31 | 1637.10 | 1637.10 |
| Cole Home Builders:Phase 2 - Lot 5 | 71090 | 2018-08-10 | 2009.25 | 2009.25 |
| Cole Home Builders:Phase 2 - Lot 5 | 71091 | 2018-09-14 | 2138.40 | 2138.40 |
| Dan A. North Builders:Custom Order - Suite 100A | 71137 | 2018-12-15 | 3500.00 | 7000.00 |
| Dan A. North Builders:McCarthy Properties | 71071 | 2018-03-28 | 8929.00 | 8929.00 |
| Dan A. North Builders:Turner Suites | 71109 | 2018-08-22 | 13300.00 | 13300.00 |
| Dan A. North Builders:Wagner Suites | 71067 | 2018-04-28 | 7890.00 | 7890.00 |
| Godwin Lighting Depot:Store #1020 | 71069 | 2018-05-30 | 2578.95 | 2578.95 |
| Godwin Lighting Depot:Store #202 | 71050 | 2018-01-14 | 7786.40 | 7786.40 |
| Godwin Lighting Depot:Store #202 | 71061 | 2018-04-17 | 1687.95 | 1687.95 |
| Godwin Lighting Depot:Store #303 | 71059 | 2018-01-31 | 1687.95 | 1687.95 |
| Godwin Lighting Depot:Store #303 | 71065 | 2018-03-26 | 2578.95 | 2578.95 |
| Godwin Lighting Depot:Store #303 | 71070 | 2018-06-11 | 2578.95 | 2578.95 |
| Godwin Lighting Depot:Store #404 | 71060 | 2018-03-27 | 1687.95 | 1687.95 |
| Godwin Lighting Depot:Store #404 | 71062 | 2018-05-02 | 1687.95 | 1687.95 |
| Godwin Lighting Depot:Store #404 | 71063 | 2018-05-19 | 1687.95 | 1687.95 |
| Godwin Lighting Depot:Store #404 | 71064 | 2018-04-22 | 2578.95 | 2578.95 |
| Godwin Lighting Depot:Store #909 | 71066 | 2018-04-28 | 2578.95 | 2578.95 |
| Godwin Lighting Depot:Store #909 | 71068 | 2018-05-10 | 2578.95 | 2578.95 |
| Kern Lighting Warehouse:Store #01 | 71119 | 2018-07-13 | 6150.00 | 6150.00 |
| Kern Lighting Warehouse:Store #01 | 71129 | 2018-07-17 | 18940.00 | 18940.00 |
| Kern Lighting Warehouse:Store #01 | 71133 | 2018-11-22 | 9839.00 | 9839.00 |
| Kern Lighting Warehouse:Store #13 | 71120 | 2018-11-01 | 8190.00 | 8190.00 |
| Kern Lighting Warehouse:Store #13 | 71123 | 2018-11-29 | 110.00 | 110.00 |
| Kern Lighting Warehouse:Store #13 | 71126 | 2018-04-13 | 12600.00 | 12600.00 |
| Kern Lighting Warehouse:Store #13 | 71131 | 2018-09-19 | 5569.00 | 5569.00 |
| Kern Lighting Warehouse:Store #13 | 71134 | 2018-12-15 | 9033.50 | 9033.50 |
| Kern Lighting Warehouse:Store #13 | 71136 | 2018-12-15 | 2222.50 | 2222.50 |
| Kern Lighting Warehouse:Store #34 | 71121 | 2018-02-01 | 6745.00 | 6745.00 |
| Kern Lighting Warehouse:Store #34 | 71124 | 2018-01-29 | 8400.00 | 8400.00 |
| Kern Lighting Warehouse:Store #34 | 71127 | 2018-05-22 | 8756.00 | 8756.00 |
| Kern Lighting Warehouse:Store #34 | 71132 | 2018-10-15 | 10723.60 | 10723.60 |
| Kern Lighting Warehouse:Store #45 | 71125 | 2018-03-28 | 8500.00 | 8500.00 |
| Kern Lighting Warehouse:Store #45 | 71128 | 2018-06-10 | 14175.00 | 14175.00 |
| Kern Lighting Warehouse:Store #45 | 71130 | 2018-08-30 | 8000.00 | 8000.00 |
| Lavery Lighting & Design:Store #JL-01 | 71117 | 2018-11-05 | 5279.00 | 5279.00 |
| Lavery Lighting & Design:Store #JL-04 | 71118 | 2018-11-16 | 11715.00 | 11715.00 |
| Lavery Lighting & Design:Store #JL-06 | 71049 | 2018-03-12 | 4694.50 | 4694.50 |
| Lavery Lighting & Design:Store #JL-08 | 71122 | 2018-02-28 | 600.00 | 600.00 |
| Lavery Lighting & Design:Store #JL-08 | 71139 | 2018-12-03 | 2708.10 | 2708.10 |
| Miscellaneous - Retail:Alison Johnson | 71053 | 2018-01-28 | 854.00 | 854.00 |
| Miscellaneous - Retail:Anne Loomis | 71096 | 2018-06-05 | 1608.00 | 1608.00 |
| Miscellaneous - Retail:Brian Stern | 71092 | 2018-01-18 | 1126.00 | 1126.00 |
| Miscellaneous - Retail:Carlos Nazar | 71095 | 2018-05-16 | 2025.00 | 2025.00 |
| Miscellaneous - Retail:David Lo | 71094 | 2018-02-23 | 1932.00 | 1932.00 |
| Miscellaneous - Retail:Doug Jacobsen | 71101 | 2018-10-09 | 1719.00 | 1719.00 |
| Miscellaneous - Retail:Jann Minor | 71098 | 2018-08-07 | 2085.00 | 2085.00 |
| Miscellaneous - Retail:Jason Helper | 71099 | 2018-09-11 | 1812.00 | 1812.00 |
| Miscellaneous - Retail:John Huhn | 71100 | 2018-09-25 | 2239.00 | 2239.00 |
| Miscellaneous - Retail:Lara Gussman | 71105 | 2018-12-10 | 1679.00 | 1679.00 |
| Miscellaneous - Retail:Melanie Hall | 71104 | 2018-11-20 | 1600.00 | 1600.00 |
| Miscellaneous - Retail:Mr. Fred Kaseman | 71056 | 2018-03-15 | 2221.00 | 2221.00 |
| Miscellaneous - Retail:Mr. Jay Jessen | 71057 | 2018-04-10 | 1239.00 | 1239.00 |
| Miscellaneous - Retail:Mrs. Anne Hemp | 71058 | 2018-04-25 | 1563.00 | 1563.00 |
| Miscellaneous - Retail:Mrs. Chris Holly | 71054 | 2018-02-20 | 1300.00 | 1300.00 |
| Miscellaneous - Retail:Ms. Jann Minor | 71055 | 2018-01-17 | 1084.00 | 1084.00 |
| Miscellaneous - Retail:Peter Karpas | 71102 | 2018-10-25 | 1714.00 | 1714.00 |
| Miscellaneous - Retail:Ruth Kuver | 71093 | 2018-02-18 | 1366.00 | 1366.00 |
| Miscellaneous - Retail:Sean Martin | 71097 | 2018-07-24 | 1542.00 | 1542.00 |
| Miscellaneous - Retail:Valesha Jones | 71103 | 2018-11-05 | 2395.00 | 2395.00 |
| Stern Commercial Contractor’s:Tittle Properties | 71107 | 2018-09-25 | 17433.00 | 17433.00 |
| Stern Commercial Contractor’s:Walker Properties | 71106 | 2018-12-12 | 21330.00 | 21330.00 |
| Stern Commercial Contractor’s:Wilson Suites | 71108 | 2018-10-26 | 14355.00 | 14355.00 |
| Thompson Lighting Stores:Store #15 | 71112 | 2018-02-11 | 3025.00 | 3025.00 |
| Thompson Lighting Stores:Store #15 | 71140 | 2018-12-15 | 11800.00 | 11800.00 |
| Thompson Lighting Stores:Store #20 | 71113 | 2018-05-16 | 3025.00 | 3025.00 |
| Thompson Lighting Stores:Store #30 | 71114 | 2018-06-12 | 3025.00 | 3025.00 |
| Thompson Lighting Stores:Store #40 | 71115 | 2018-07-16 | 3025.00 | 3025.00 |
| Thompson Lighting Stores:Store #50 | 71116 | 2018-06-28 | 3025.00 | 3025.00 |
Review paid invoces. For instance, dr: cash, cr: AR.
| name | num | date | amt |
|---|---|---|---|
| Baker’s Professional Lighting:Store #05 | 142 | 2018-03-16 | 2391.00 |
| Baker’s Professional Lighting:Store #05 | 71110 | 2018-02-14 | 2391.00 |
| Baker’s Professional Lighting:Store #10 | 201 | 2018-06-11 | 2038.00 |
| Baker’s Professional Lighting:Store #10 | 71111 | 2018-05-09 | 2038.00 |
| Baker’s Professional Lighting:Store #10 | 71138 | 2018-12-07 | 10680.48 |
| Baker’s Professional Lighting:Store #15 | 157 | 2018-03-30 | 1885.00 |
| Baker’s Professional Lighting:Store #15 | 71052 | 2018-02-27 | 1885.00 |
| Baker’s Professional Lighting:Store #15 | 71135 | 2018-12-15 | 1422.00 |
| Baker’s Professional Lighting:Store #20 | 169 | 2018-04-13 | 1872.00 |
| Baker’s Professional Lighting:Store #20 | 71048 | 2018-03-11 | 1872.00 |
| Baker’s Professional Lighting:Store #25 | 130 | 2018-02-09 | 2381.00 |
| Baker’s Professional Lighting:Store #25 | 71047 | 2018-01-06 | 2381.00 |
| Cole Home Builders:Phase 1 - Lot 2 | 11057 | 2018-04-16 | 2187.45 |
| Cole Home Builders:Phase 1 - Lot 2 | 71088 | 2018-02-12 | 2187.45 |
| Cole Home Builders:Phase 1 - Lot 4 | 11167 | 2018-07-20 | 2187.45 |
| Cole Home Builders:Phase 1 - Lot 4 | 71086 | 2018-05-24 | 2187.45 |
| Cole Home Builders:Phase 1 - Lot 5 | 11123 | 2018-06-15 | 2187.45 |
| Cole Home Builders:Phase 1 - Lot 5 | 11154 | 2018-07-16 | 1637.10 |
| Cole Home Builders:Phase 1 - Lot 5 | 11184 | 2018-08-17 | 2187.45 |
| Cole Home Builders:Phase 1 - Lot 5 | 11191 | 2018-08-15 | 2009.25 |
| Cole Home Builders:Phase 1 - Lot 5 | 11199 | 2018-08-15 | 1637.10 |
| Cole Home Builders:Phase 1 - Lot 5 | 11201 | 2018-09-14 | 1637.10 |
| Cole Home Builders:Phase 1 - Lot 5 | 11213 | 2018-09-17 | 2009.25 |
| Cole Home Builders:Phase 1 - Lot 5 | 11219 | 2018-10-15 | 2138.40 |
| Cole Home Builders:Phase 1 - Lot 5 | 11223 | 2018-09-17 | 2009.25 |
| Cole Home Builders:Phase 1 - Lot 5 | 11230 | 2018-10-15 | 2009.25 |
| Cole Home Builders:Phase 1 - Lot 5 | 11250 | 2018-11-16 | 2138.40 |
| Cole Home Builders:Phase 1 - Lot 5 | 11257 | 2018-11-16 | 2138.40 |
| Cole Home Builders:Phase 1 - Lot 5 | 11270 | 2018-11-16 | 2138.40 |
| Cole Home Builders:Phase 1 - Lot 5 | 71073 | 2018-08-31 | 2138.40 |
| Cole Home Builders:Phase 1 - Lot 5 | 71074 | 2018-08-24 | 2138.40 |
| Cole Home Builders:Phase 1 - Lot 5 | 71075 | 2018-08-17 | 2138.40 |
| Cole Home Builders:Phase 1 - Lot 5 | 71076 | 2018-07-16 | 2138.40 |
| Cole Home Builders:Phase 1 - Lot 5 | 71077 | 2018-07-31 | 2009.25 |
| Cole Home Builders:Phase 1 - Lot 5 | 71078 | 2018-07-27 | 2009.25 |
| Cole Home Builders:Phase 1 - Lot 5 | 71079 | 2018-07-12 | 2009.25 |
| Cole Home Builders:Phase 1 - Lot 5 | 71080 | 2018-06-12 | 2009.25 |
| Cole Home Builders:Phase 1 - Lot 5 | 71082 | 2018-06-15 | 1637.10 |
| Cole Home Builders:Phase 1 - Lot 5 | 71084 | 2018-05-18 | 1637.10 |
| Cole Home Builders:Phase 1 - Lot 5 | 71085 | 2018-06-07 | 2187.45 |
| Cole Home Builders:Phase 1 - Lot 5 | 71087 | 2018-04-16 | 2187.45 |
| Cole Home Builders:Phase 1 - Lot 5 | 71089 | 2018-07-05 | 1637.10 |
| Cole Home Builders:Phase 2 - Lot 5 | 11030 | 2018-03-16 | 2187.45 |
| Cole Home Builders:Phase 2 - Lot 5 | 11049 | 2018-04-16 | 4364.00 |
| Cole Home Builders:Phase 2 - Lot 5 | 11173 | 2018-07-16 | 1637.10 |
| Cole Home Builders:Phase 2 - Lot 5 | 11190 | 2018-08-15 | 1637.10 |
| Cole Home Builders:Phase 2 - Lot 5 | 11240 | 2018-10-19 | 2009.25 |
| Cole Home Builders:Phase 2 - Lot 5 | 11280 | 2018-11-16 | 2138.40 |
| Cole Home Builders:Phase 2 - Lot 5 | 71051 | 2018-02-10 | 4364.00 |
| Cole Home Builders:Phase 2 - Lot 5 | 71072 | 2018-01-28 | 2187.45 |
| Cole Home Builders:Phase 2 - Lot 5 | 71081 | 2018-06-12 | 1637.10 |
| Cole Home Builders:Phase 2 - Lot 5 | 71083 | 2018-05-31 | 1637.10 |
| Cole Home Builders:Phase 2 - Lot 5 | 71090 | 2018-08-10 | 2009.25 |
| Cole Home Builders:Phase 2 - Lot 5 | 71091 | 2018-09-14 | 2138.40 |
| Dan A. North Builders:Custom Order - Suite 100A | 71137 | 2018-12-15 | 3500.00 |
| Dan A. North Builders:McCarthy Properties | 5790 | 2018-04-30 | 8929.00 |
| Dan A. North Builders:McCarthy Properties | 71071 | 2018-03-28 | 8929.00 |
| Dan A. North Builders:Turner Suites | 6111 | 2018-09-28 | 13300.00 |
| Dan A. North Builders:Turner Suites | 71109 | 2018-08-22 | 13300.00 |
| Dan A. North Builders:Wagner Suites | 5810 | 2018-05-30 | 7890.00 |
| Dan A. North Builders:Wagner Suites | 71067 | 2018-04-28 | 7890.00 |
| Godwin Lighting Depot:Store #1020 | 57811 | 2018-06-29 | 2578.95 |
| Godwin Lighting Depot:Store #1020 | 71069 | 2018-05-30 | 2578.95 |
| Godwin Lighting Depot:Store #202 | 57702 | 2018-02-28 | 7786.40 |
| Godwin Lighting Depot:Store #202 | 57749 | 2018-05-31 | 1687.95 |
| Godwin Lighting Depot:Store #202 | 71050 | 2018-01-14 | 7786.40 |
| Godwin Lighting Depot:Store #202 | 71061 | 2018-04-17 | 1687.95 |
| Godwin Lighting Depot:Store #303 | 57713 | 2018-02-28 | 1687.95 |
| Godwin Lighting Depot:Store #303 | 57713 | 2018-04-30 | 2578.95 |
| Godwin Lighting Depot:Store #303 | 57820 | 2018-07-31 | 2578.95 |
| Godwin Lighting Depot:Store #303 | 71059 | 2018-01-31 | 1687.95 |
| Godwin Lighting Depot:Store #303 | 71065 | 2018-03-26 | 2578.95 |
| Godwin Lighting Depot:Store #303 | 71070 | 2018-06-11 | 2578.95 |
| Godwin Lighting Depot:Store #404 | 57730 | 2018-04-30 | 1687.95 |
| Godwin Lighting Depot:Store #404 | 57767 | 2018-05-31 | 2578.95 |
| Godwin Lighting Depot:Store #404 | 57790 | 2018-06-29 | 1687.95 |
| Godwin Lighting Depot:Store #404 | 57801 | 2018-06-29 | 1687.95 |
| Godwin Lighting Depot:Store #404 | 71060 | 2018-03-27 | 1687.95 |
| Godwin Lighting Depot:Store #404 | 71062 | 2018-05-02 | 1687.95 |
| Godwin Lighting Depot:Store #404 | 71063 | 2018-05-19 | 1687.95 |
| Godwin Lighting Depot:Store #404 | 71064 | 2018-04-22 | 2578.95 |
| Godwin Lighting Depot:Store #909 | 57777 | 2018-05-31 | 2578.95 |
| Godwin Lighting Depot:Store #909 | 57799 | 2018-06-29 | 2578.95 |
| Godwin Lighting Depot:Store #909 | 71066 | 2018-04-28 | 2578.95 |
| Godwin Lighting Depot:Store #909 | 71068 | 2018-05-10 | 2578.95 |
| Kern Lighting Warehouse:Store #01 | 5740 | 2018-07-29 | 6150.00 |
| Kern Lighting Warehouse:Store #01 | 5890 | 2018-09-14 | 18940.00 |
| Kern Lighting Warehouse:Store #01 | 5977 | 2018-12-11 | 9839.00 |
| Kern Lighting Warehouse:Store #01 | 71119 | 2018-07-13 | 6150.00 |
| Kern Lighting Warehouse:Store #01 | 71129 | 2018-07-17 | 18940.00 |
| Kern Lighting Warehouse:Store #01 | 71133 | 2018-11-22 | 9839.00 |
| Kern Lighting Warehouse:Store #13 | 5750 | 2018-03-02 | 110.00 |
| Kern Lighting Warehouse:Store #13 | 5791 | 2018-11-30 | 8190.00 |
| Kern Lighting Warehouse:Store #13 | 5832 | 2018-06-08 | 12600.00 |
| Kern Lighting Warehouse:Store #13 | 5930 | 2018-11-16 | 5569.00 |
| Kern Lighting Warehouse:Store #13 | 5999 | 2018-12-15 | 9033.50 |
| Kern Lighting Warehouse:Store #13 | 71120 | 2018-11-01 | 8190.00 |
| Kern Lighting Warehouse:Store #13 | 71123 | 2018-11-29 | 110.00 |
| Kern Lighting Warehouse:Store #13 | 71126 | 2018-04-13 | 12600.00 |
| Kern Lighting Warehouse:Store #13 | 71131 | 2018-09-19 | 5569.00 |
| Kern Lighting Warehouse:Store #13 | 71134 | 2018-12-15 | 9033.50 |
| Kern Lighting Warehouse:Store #13 | 71136 | 2018-12-15 | 2222.50 |
| Kern Lighting Warehouse:Store #34 | 5749 | 2018-03-02 | 8400.00 |
| Kern Lighting Warehouse:Store #34 | 5790 | 2018-03-16 | 6745.00 |
| Kern Lighting Warehouse:Store #34 | 5850 | 2018-07-31 | 8756.00 |
| Kern Lighting Warehouse:Store #34 | 5950 | 2018-12-14 | 10723.60 |
| Kern Lighting Warehouse:Store #34 | 71121 | 2018-02-01 | 6745.00 |
| Kern Lighting Warehouse:Store #34 | 71124 | 2018-01-29 | 8400.00 |
| Kern Lighting Warehouse:Store #34 | 71127 | 2018-05-22 | 8756.00 |
| Kern Lighting Warehouse:Store #34 | 71132 | 2018-10-15 | 10723.60 |
| Kern Lighting Warehouse:Store #45 | 5824 | 2018-05-02 | 8500.00 |
| Kern Lighting Warehouse:Store #45 | 5861 | 2018-08-17 | 14175.00 |
| Kern Lighting Warehouse:Store #45 | 5910 | 2018-10-19 | 8000.00 |
| Kern Lighting Warehouse:Store #45 | 71125 | 2018-03-28 | 8500.00 |
| Kern Lighting Warehouse:Store #45 | 71128 | 2018-06-10 | 14175.00 |
| Kern Lighting Warehouse:Store #45 | 71130 | 2018-08-30 | 8000.00 |
| Lavery Lighting & Design:Store #JL-01 | 11301 | 2018-12-15 | 5279.00 |
| Lavery Lighting & Design:Store #JL-01 | 71117 | 2018-11-05 | 5279.00 |
| Lavery Lighting & Design:Store #JL-04 | 11311 | 2018-12-01 | 11715.00 |
| Lavery Lighting & Design:Store #JL-04 | 71118 | 2018-11-16 | 11715.00 |
| Lavery Lighting & Design:Store #JL-06 | 11128 | 2018-04-30 | 4694.50 |
| Lavery Lighting & Design:Store #JL-06 | 71049 | 2018-03-12 | 4694.50 |
| Lavery Lighting & Design:Store #JL-08 | 11111 | 2018-03-30 | 600.00 |
| Lavery Lighting & Design:Store #JL-08 | 71122 | 2018-02-28 | 600.00 |
| Lavery Lighting & Design:Store #JL-08 | 71139 | 2018-12-03 | 2708.10 |
| Miscellaneous - Retail:Alison Johnson | 254 | 2018-01-28 | 854.00 |
| Miscellaneous - Retail:Alison Johnson | 71053 | 2018-01-28 | 854.00 |
| Miscellaneous - Retail:Anne Loomis | 2546 | 2018-06-05 | 1608.00 |
| Miscellaneous - Retail:Anne Loomis | 71096 | 2018-06-05 | 1608.00 |
| Miscellaneous - Retail:Brian Stern | 11124 | 2018-01-18 | 1126.00 |
| Miscellaneous - Retail:Brian Stern | 71092 | 2018-01-18 | 1126.00 |
| Miscellaneous - Retail:Carlos Nazar | 1125 | 2018-05-16 | 2025.00 |
| Miscellaneous - Retail:Carlos Nazar | 71095 | 2018-05-16 | 2025.00 |
| Miscellaneous - Retail:David Lo | 12357 | 2018-02-23 | 1932.00 |
| Miscellaneous - Retail:David Lo | 71094 | 2018-02-23 | 1932.00 |
| Miscellaneous - Retail:Doug Jacobsen | 71101 | 2018-10-09 | 1719.00 |
| Miscellaneous - Retail:Doug Jacobsen | 99611 | 2018-10-09 | 1719.00 |
| Miscellaneous - Retail:Jann Minor | 5587 | 2018-08-07 | 2085.00 |
| Miscellaneous - Retail:Jann Minor | 71098 | 2018-08-07 | 2085.00 |
| Miscellaneous - Retail:Jason Helper | 6687 | 2018-09-11 | 1812.00 |
| Miscellaneous - Retail:Jason Helper | 71099 | 2018-09-11 | 1812.00 |
| Miscellaneous - Retail:John Huhn | 71100 | 2018-09-25 | 2239.00 |
| Miscellaneous - Retail:John Huhn | 71105 | 2018-09-25 | 2239.00 |
| Miscellaneous - Retail:Lara Gussman | 66587 | 2018-12-10 | 1679.00 |
| Miscellaneous - Retail:Lara Gussman | 71105 | 2018-12-10 | 1679.00 |
| Miscellaneous - Retail:Melanie Hall | 55449 | 2018-11-20 | 1600.00 |
| Miscellaneous - Retail:Melanie Hall | 71104 | 2018-11-20 | 1600.00 |
| Miscellaneous - Retail:Mr. Fred Kaseman | 71056 | 2018-03-15 | 2221.00 |
| Miscellaneous - Retail:Mr. Fred Kaseman | 741 | 2018-03-15 | 2221.00 |
| Miscellaneous - Retail:Mr. Jay Jessen | 489 | 2018-04-10 | 1239.00 |
| Miscellaneous - Retail:Mr. Jay Jessen | 71057 | 2018-04-10 | 1239.00 |
| Miscellaneous - Retail:Mrs. Anne Hemp | 265 | 2018-04-25 | 1563.00 |
| Miscellaneous - Retail:Mrs. Anne Hemp | 71058 | 2018-04-25 | 1563.00 |
| Miscellaneous - Retail:Mrs. Chris Holly | 305 | 2018-02-20 | 1300.00 |
| Miscellaneous - Retail:Mrs. Chris Holly | 71054 | 2018-02-20 | 1300.00 |
| Miscellaneous - Retail:Ms. Jann Minor | 555 | 2018-01-17 | 1084.00 |
| Miscellaneous - Retail:Ms. Jann Minor | 71055 | 2018-01-17 | 1084.00 |
| Miscellaneous - Retail:Peter Karpas | 115789 | 2018-10-25 | 1714.00 |
| Miscellaneous - Retail:Peter Karpas | 71102 | 2018-10-25 | 1714.00 |
| Miscellaneous - Retail:Ruth Kuver | 5467 | 2018-02-18 | 1366.00 |
| Miscellaneous - Retail:Ruth Kuver | 71093 | 2018-02-18 | 1366.00 |
| Miscellaneous - Retail:Sean Martin | 35587 | 2018-07-24 | 1542.00 |
| Miscellaneous - Retail:Sean Martin | 71097 | 2018-07-24 | 1542.00 |
| Miscellaneous - Retail:Valesha Jones | 101 | 2018-11-05 | 2395.00 |
| Miscellaneous - Retail:Valesha Jones | 71103 | 2018-11-05 | 2395.00 |
| Stern Commercial Contractor’s:Tittle Properties | 1052 | 2018-11-29 | 17433.00 |
| Stern Commercial Contractor’s:Tittle Properties | 71107 | 2018-09-25 | 17433.00 |
| Stern Commercial Contractor’s:Walker Properties | 1103 | 2018-02-15 | 21330.00 |
| Stern Commercial Contractor’s:Walker Properties | 71106 | 2018-12-12 | 21330.00 |
| Stern Commercial Contractor’s:Wilson Suites | 1098 | 2018-11-30 | 14355.00 |
| Stern Commercial Contractor’s:Wilson Suites | 71108 | 2018-10-26 | 14355.00 |
| Thompson Lighting Stores:Store #15 | 71112 | 2018-02-11 | 3025.00 |
| Thompson Lighting Stores:Store #15 | 71140 | 2018-12-15 | 11800.00 |
| Thompson Lighting Stores:Store #15 | 8111 | 2018-04-25 | 3025.00 |
| Thompson Lighting Stores:Store #20 | 71113 | 2018-05-16 | 3025.00 |
| Thompson Lighting Stores:Store #20 | 7233 | 2018-07-27 | 3025.00 |
| Thompson Lighting Stores:Store #30 | 71114 | 2018-06-12 | 3025.00 |
| Thompson Lighting Stores:Store #30 | 7253 | 2018-09-28 | 3025.00 |
| Thompson Lighting Stores:Store #40 | 71115 | 2018-07-16 | 3025.00 |
| Thompson Lighting Stores:Store #40 | 7279 | 2018-09-28 | 3025.00 |
| Thompson Lighting Stores:Store #50 | 71116 | 2018-06-28 | 3025.00 |
| Thompson Lighting Stores:Store #50 | 7262 | 2018-08-15 | 3025.00 |
AR balance
| name | arbal |
|---|---|
| Baker’s Professional Lighting:Store #10 | 10680.48 |
| Baker’s Professional Lighting:Store #15 | 1422.00 |
| Dan A. North Builders:Custom Order - Suite 100A | 3500.00 |
| Kern Lighting Warehouse:Store #13 | 2222.50 |
| Lavery Lighting & Design:Store #JL-08 | 2708.10 |
| Thompson Lighting Stores:Store #15 | 11800.00 |
JV date
Sales and AR
2
Inactive customers
Citation
- “Data mining your general ledger with Excel” (J. Carlton Collins, CPA, 1/1/2017)
tidyxl,unpivottidyversejanitorskimrcollapsibleTreeggTimeSeriesd3heatmapwidyrigraphggraph,gganimatetsibbleR Markdown,knitr,xaringan
Copyright @ Stewart Li
stewardli8@msn.com
China | Singapore | New Zealand
…