Spreadsheet: 744041d1628875857-running-balance-with-multiple-bank-account-transactions-in-one-table-accountingtemplatebackup
Sheet: Master Data Table

Master Data Table (READ-ONLY)
Account | Month/Year | Account | Description | Memo | Credit/Debit | Category | Reviewed | Amount | Sum of Amount
2021-01-30 00:00:00 | January 2021 | Asset - PayPal | Sample Transaction 1 | (blank) | Debit | Expense - Commissions and Fees | Yes | -5 | -5
2021-01-29 00:00:00 | January 2021 | Asset - Fidelity 1 | Sample Transaction 2 | (blank) | Credit | Income - JMP Sales | Yes | 150.32 | 150.32
2021-01-28 00:00:00 | February 2021 | Asset - Fidelity 1 | Sample Transaction 3 | (blank) | Debit | Expense - Advertising | Yes | -35 | -35
2021-01-27 00:00:00 | February 2021 | Asset - Fidelity 2 | Sample Transaction 4 | (blank) | Debit | Expense - Interest (Mortgage) | Yes | -5 | -5
2021-01-26 00:00:00 | March 2021 | Asset - Fidelity 3 | Sample Transaction 5 | (blank) | Credit | Income - Contract Photography | Yes | 150.01 | 150.01
2021-01-25 00:00:00 | March 2021 | Asset - Moxey | Sample Transaction 6 | (blank) | Debit | Expense - Employee Benefit Program | Yes | -35.53 | -35.53
2021-01-24 00:00:00 | April 2021 | Asset - Venmo | Sample Transaction 7 | (blank) | Debit | Expense - Interest (Other) | Yes | -5 | -5
2021-01-23 00:00:00 | April 2021 | Asset - Square | Sample Transaction 8 | (blank) | Credit | Income - JMP Sales | Yes | 150 | 150
2021-01-22 00:00:00 | May 2021 | Asset - Venmo | Sample Transaction 9 | (blank) | Debit | Expense - Depreciation | Yes | -35 | -35
2021-01-21 00:00:00 | May 2021 | Asset - Moxey | Sample Transaction 10 | (blank) | Debit | Expense - Interest (Mortgage) | Yes | -5 | -5
2021-01-20 00:00:00 | July 2021 | Asset - PayPal | Sample Transaction 13 | (blank) | Debit | Expense - Depreciation | Yes | -5 | -5
2021-01-20 00:00:00 | June 2021 | Asset - Fidelity 1 | Sample Transaction 12 | (blank) | Debit | Expense - Advertising | Yes | -35 | -35
2021-01-20 00:00:00 | June 2021 | Asset - Venmo | Sample Transaction 11 | (blank) | Credit | Income - JMP Sales | Yes | 150 | 150
2021-01-19 00:00:00 | July 2021 | Asset - Fidelity 1 | Sample Transaction 14 | (blank) | Credit | Income - Contract Photography | Yes | 150 | 150
2021-01-18 00:00:00 | August 2021 | Asset - Fidelity 3 | Sample Transaction 15 | (blank) | Debit | Expense - Advertising | Yes | -35 | -35
2021-01-17 00:00:00 | August 2021 | Asset - Fidelity 1 | Sample Transaction 16 | (blank) | Debit | Expense - Depreciation | Yes | -35 | -35
2021-01-16 00:00:00 | September 2021 | Asset - Fidelity 2 | Sample Transaction 17 | (blank) | Debit | Expense - Interest (Mortgage) | Yes | -5 | -5
2021-01-15 00:00:00 | September 2021 | Asset - Fidelity 1 | Sample Transaction 18 | (blank) | Credit | Income - JMP Sales | Yes | 150 | 150
2021-01-14 00:00:00 | October 2021 | Asset - Fidelity 1 | Sample Transaction 19 | (blank) | Debit | Expense - Advertising | Yes | -35 | -35
2021-01-13 00:00:00 | October 2021 | Asset - PayPal | Sample Transaction 20 | (blank) | Debit | Expense - Depreciation | Yes | -5 | -5
2021-01-12 00:00:00 | November 2021 | Asset - Fidelity 1 | Sample Transaction 21 | (blank) | Credit | Income - Contract Photography | Yes | 150 | 150
2021-01-11 00:00:00 | November 2021 | Asset - Fidelity 1 | Sample Transaction 22 | (blank) | Debit | Expense - Advertising | Yes | -35 | -35
2021-01-11 00:00:00 | November 2021 | Asset - Fidelity 1 | Sample Transaction 23 | (blank) | Debit | Expense - Advertising | Yes | -45 | -45