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

 |  | Transactions 2021
 |  |  |  |  |  |  | Have account balance (Column H) reflect the running total of the Account the transaction as posted in (Column A)
Account | Month/Year | Date | Description | Memo | Credit/Debit | Category | Amount | Account Balance | Reviewed | Invoice # | Client | Platform | Sale Amount | Sales Tax | Shipping | Net Deposit (Must Match Amount in Green Table)
Asset - PayPal | January 2021 | 2021-01-30 00:00:00 | Sample Transaction 1 |  |  | Expense - Commissions and Fees | -5 |  | Yes
Asset - Fidelity 1 | January 2021 | 2021-01-29 00:00:00 | Sample Transaction 2 |  |  | Income - JMP Sales | 150.32 |  | Yes | 54241 | [NAME] | Tave | 152 | 1.5
Asset - Fidelity 1 | February 2021 | 2021-01-28 00:00:00 | Sample Transaction 3 |  |  | Expense - Advertising | -35 |  | Yes
Asset - Fidelity 2 | February 2021 | 2021-01-27 00:00:00 | Sample Transaction 4 |  |  | Expense - Interest (Mortgage) | -5 |  | Yes
Asset - Fidelity 3 | March 2021 | 2021-01-26 00:00:00 | Sample Transaction 5 |  |  | Income - Contract Photography | 150.01 |  | Yes | 54242 | [NAME] | Tave | 155 | 1
Asset - Moxey | March 2021 | 2021-01-25 00:00:00 | Sample Transaction 6 |  |  | Expense - Employee Benefit Program | -35.53 |  | Yes
Asset - Venmo | April 2021 | 2021-01-24 00:00:00 | Sample Transaction 7 |  |  | Expense - Interest (Other) | -5 |  | Yes
Asset - Square | April 2021 | 2021-01-23 00:00:00 | Sample Transaction 8 |  |  | Income - JMP Sales | 150 |  | Yes | 39821 | [NAME] | Pixieset | 157 | 4
Asset - Venmo | May 2021 | 2021-01-22 00:00:00 | Sample Transaction 9 |  |  | Expense - Depreciation | -35 |  | Yes
Asset - Moxey | May 2021 | 2021-01-21 00:00:00 | Sample Transaction 10 |  |  | Expense - Interest (Mortgage) | -5 |  | Yes
Asset - Venmo | June 2021 | 2021-01-20 00:00:00 | Sample Transaction 11 |  |  | Income - JMP Sales | 150 |  | Yes | 54243 | [NAME] | Tave | 160 | 12
Asset - Fidelity 1 | June 2021 | 2021-01-20 00:00:00 | Sample Transaction 12 |  |  | Expense - Advertising | -35 |  | Yes
Asset - PayPal | July 2021 | 2021-01-20 00:00:00 | Sample Transaction 13 |  |  | Expense - Depreciation | -5 |  | Yes
Asset - Fidelity 1 | July 2021 | 2021-01-19 00:00:00 | Sample Transaction 14 |  |  | Income - Contract Photography | 150 |  | Yes | 39822 | [NAME] | Pixieset | 160 | 5
Asset - Fidelity 3 | August 2021 | 2021-01-18 00:00:00 | Sample Transaction 15 |  |  | Expense - Advertising | -35 |  | Yes
Asset - Fidelity 1 | August 2021 | 2021-01-17 00:00:00 | Sample Transaction 16 |  |  | Expense - Depreciation | -35 |  | Yes
Asset - Fidelity 2 | September 2021 | 2021-01-16 00:00:00 | Sample Transaction 17 |  |  | Expense - Interest (Mortgage) | -5 |  | Yes
Asset - Fidelity 1 | September 2021 | 2021-01-15 00:00:00 | Sample Transaction 18 |  |  | Income - JMP Sales | 150 |  | Yes | 54244 | [NAME] | Tave | 160 | 12
Asset - Fidelity 1 | October 2021 | 2021-01-14 00:00:00 | Sample Transaction 19 |  |  | Expense - Advertising | -35 |  | Yes
Asset - PayPal | October 2021 | 2021-01-13 00:00:00 | Sample Transaction 20 |  |  | Expense - Depreciation | -5 |  | Yes
Asset - Fidelity 1 | November 2021 | 2021-01-12 00:00:00 | Sample Transaction 21 |  |  | Income - Contract Photography | 150 |  | Yes | 39823 | [NAME] | Pixieset | 160 | 5
Asset - Fidelity 1 | November 2021 | 2021-01-11 00:00:00 | Sample Transaction 22 |  |  | Expense - Advertising | -35 |  | Yes
Asset - Fidelity 1 | November 2021 | 2021-01-11 00:00:00 | Sample Transaction 23 |  |  | Expense - Advertising | -45 |  | Yes