Spreadsheet: 726770d1617444940-sumifs-function-doesnt-calculate-values-as-expected-accounting-module-1-sumproduct
Sheet: Example

 | My Example Business |  |  | EXAMPLE PAGE |  |  | In the top right corner of some of the cells is a red triangle - this indictes helpful information |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EXAMPLE PAGE
 | January |  |  |  |  |  | MONEY IN |  |  |  |  |  |  | MONEY OUT
 | Details |  |  |  |  |  | Other Funds |  | Income |  |  | Total Money In |  | Cost of Goods Sold |  | Expenses |  |  |  |  |  |  |  | Other Funds Paid Out |  |  |  |  |  |  |  | Total Money Out |  | BANK BALANCE
 | Date | Payment Type | Name | Description | Ref |  | Owner's Deposit (Capital) | Loans Received | Clothes | Access-ories | Bank Interest Received |  |  | Stock Purchases | Freight | Bank Charges | Enter-tainment (50%) | Phone | Stationery | Vehicle Expenses | Net Wages/ Salaries | Interest Expense (Loans) |  | Asset Purchases | Loan Re-payments | Petty Cash | Credit Card Payments | Transfer to/from Other Bank Account (EG "Savings'' | Owner's Personal Expenses | Income Tax Payments | Payroll Tax |  |  |  | R
 |  |  |  | TOTALS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | Opening Bank Balance
 | 2018-01-01 00:00:00 | Deposit | Loan People | Bank Loan Drawdown |  |  |  | 10000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R | R means Reconciled - it is on bank statement; the small dash means it is not on bank statement
 | 2018-01-01 00:00:00 |  | Apparel Group | Purchase Stock  - Clothes and Accessories | Inv 101 |  |  |  |  |  |  |  |  | 900 | 80 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R
 | 2018-01-05 00:00:00 |  | Apparel Group | Payment received for purchases returns - faulty stock | Cr 101a |  |  |  |  |  |  |  |  | -200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R
 | 2018-01-06 00:00:00 | ATM |  | Cash withdrawal for Petty Cash float |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 |  |  |  |  |  |  |  |  | R
 | 2018-01-08 00:00:00 | Bank Pmt | Big Bank | Bank fees |  |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R
 | 2018-01-11 00:00:00 |  | XX Gas Station | Fuel | Receipt 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R
 | 2018-01-15 00:00:00 |  | Mr West | Clothing Sales | Inv 0001 |  |  |  | 120 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R
 | 2018-01-20 00:00:00 | Deposit | Me | Money paid in by owner |  |  | 1000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R
 | 2018-01-20 00:00:00 | Transfer |  | Transfer to Savings |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8000 |  |  |  |  |  |  | R
 | 2018-01-21 00:00:00 | POS | Stationery Retailers | Stapler, pens, envelopes | Receipt 2 |  |  |  |  |  |  |  |  |  |  |  |  | 25 | 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R
 | 2018-01-21 00:00:00 | DC |  | Payment to Credit Card |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 200 |  |  |  |  |  |  |  | R
 | 2018-01-21 00:00:00 | DC | M Frank | WAGES : Payment for Week ending 20 January |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 180 |  |  |  |  |  |  |  |  |  |  |  |  |  | R
 | 1900-01-22 00:00:00 |  | [NAME] | Accessories Sales | Inv 0002 |  |  |  |  | 150 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R
 | 2018-01-22 00:00:00 |  | Golden Café | Take client to lunch $78 | Receipt 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39 |  |  |  |  |  | R
 | 2018-01-25 00:00:00 |  | Mr West | [NAME] | Cr 0002a |  |  |  | -12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R
 | 2018-01-26 00:00:00 |  | Government Agency | Pay Income Tax |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 250 |  |  |  |  | R
 | 2018-01-27 00:00:00 |  | Government Agency | Pay Payroll Tax |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 110 |  |  |  | R
 | 2018-01-31 00:00:00 | Bank Pmt | Big Bank | Bank Interest received |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R
 | 2018-01-31 00:00:00 | DD | Loan People | Loan and Interest Repaid |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 110 |  |  | 280 |  |  |  |  |  |  |  |  |  | R
 | 2018-01-31 00:00:00 | DC | Personal | School fees of Owner's child |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 200 |  |  |  |  |  | R
 | 2018-01-31 00:00:00 | DC | IT Specialists | Laptop | Inv 89680 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 800 |  |  |  |  |  |  |  |  |  |  | R
 | 2018-01-31 00:00:00 |  | Me | Business Expenses Paid with Personal Funds |  |  | 50 |  |  |  |  |  |  |  |  |  |  |  |  | 50 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R
 | 2018-01-31 00:00:00 | Transfer |  | Transfer from Savings |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -2000 |  |  |  |  |  |  | R
 | 2018-01-31 00:00:00 | Cash |  | Petty Cash income and expenses |  |  |  |  |  | 25 |  |  |  |  |  |  |  |  | 65 | 40 |  |  |  |  |  | -80 |  |  |  |  |  |  |  |  | R
 | 2018-01-31 00:00:00 | DD | Telephone Company | Plan for mobile phone - January |  |  |  |  |  |  |  |  |  |  |  |  |  | 45 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Closing Balance