A transaction (journal entry) is identified by a transaction ID number so all items marked with that same transaction ID are part of the same transaction/same journal entry.
- How many transactions posted on 12/25 have at least one sales account being credited?
- What is the amount of sales being credited on 12/25?
(sales accounts only; do not include freight revenue)
- List the transaction ID for all transactions posted on 12/25 that have at least one COGS account being debited (look in the account tags column to identify the COGS accounts).
- What is the amount of COGS that is being debited on 12/25?
Transactions Transaction ID Account Account Description Account Tags Tasks Status Title Posted Memo Debit Credit J235 Open - December 25th transactions J235 J235 J235 J235 J235 J235 42300 42100 42200 15300 50200 23100 15200 50100 23000 15400 50300 44100 12000 Sales: Lumber Sales: Drywall Sales: Hardware Hardware Material: Hardware GST Charged on Sales Drywall Material: Drywall PST Payable Lumber Material: Lumber Freight Revenue Accounts Receivable 2014-12-25 2014-12-25 Bayswater School Board 2014-12-25 Bayswater School Board 2014-12-25 Bayswater School Board 2014-12-25 Bayswater School Board 2014-12-25 Bayswater School Board 2014-12-25 Bayswater School Board 2014-12-25 Bayswater School Board 2014-12-25 Bayswater School Board 2014-12-25 Bayswater School Board 2014-12-25 Bayswater School Board 2014-12-25 Bayswater School Board 2014-12-25 Bayswater School Board 2014-12-25 Bayswater School Board revenue, ebitda revenue, ebitda revenue, ebitda asset cogs, ebitda, expense liability, income_tax, ap asset cogs, ebitda, expense liability, income_tax, ap asset cogs, ebitda, expense revenue, ebitda ar, asset J235 6,605.96 0.00 0.00 0.00 0.00 425.99 0.00 0.00 145.31 0.00 0.00 392.00 0.00 5,642.66 6,605.96 1,800.00 283.50 2,835.00 425.99 0.00 299.61 145.31 0.00 349.55 392.00 0.00 75.00 0.00 J235 J235 J235 J235 J235 J235 Open J2949 Reporting Adjustment J2949 J2949 J2949 J2949 J2949 42400 42200 23100 42300 12030 Sales: Roofing Sales: Hardware HST Charged On Sales Sales: Lumber Accounts Receivable revenue, ebitda revenue, ebitda liability, income_tax, ap revenue, ebitda ar, asset 2014-12-25 2014-12-25 customer71 2014-12-25 customer71 2014-12-25 customer71 2014-12-25 customer71 2014-12-25 customer71 52,073.42 0.00 0.00 0.00 0.00 52,073.42 52,073.42 41,166.67 2,000.00 5,990.08 2,916.67 0.00 Open Reporting Adjustment J2950 J2950 J2950 J2950 J2950 J2950 23100 42200 42300 42400 12030 HST Charged On Sales Sales: Hardware Sales: Lumber Sales: Roofing Accounts Receivable liability, income_tax, ap revenue, ebitda revenue, ebitda revenue, ebitda ar, asset 2014-12-25 2014-12-25 customer72 2014-12-25 customer72 2014-12-25 customer72 2014-12-25 customer72 2014-12-25 customer72 78,110.13 0.00 0.00 0.00 0.00 78,110.13 78,110.13 8,985.13 3,000.00 4,375.00 61,750.00 0.00 J2951 Revenue greater than $100,000 J2951 J2951 J2951 J2951 23100 42400 42300 42200 12030 HST Charged On Sales Sales: Roofing Sales: Lumber Sales: Hardware Accounts Receivable liability, income_tax, ap revenue, ebitda revenue, ebitda revenue, ebitda ar, asset 2014-12-25 2014-12-25 customer71 2014-12-25 customer71 2014-12-25 customer71 2014-12-25 customer71 2014-12-25 customer71 110,212.99 0.00 0.00 0.00 0.00 110,212.99 110,212.99 12,675.49 86,475.00 6,562.50 4,500.00 0.00 J2951 Open December 25th transactions J2952 J2952 J2952 J2952 J2952 J2952 42400 42300 23100 42200 12030 Sales: Roofing Sales: Lumber HST Charged On Sales Sales: Hardware Accounts Receivable revenue, ebitda revenue, ebitda liability, income_tax, ap revenue, ebitda ar, asset 2014-12-25 2014-12-25 customer72 2014-12-25 customer72 2014-12-25 customer72 2014-12-25 customer72 2014-12-25 customer72 36,737.66 0.00 0.00 0.00 0.00 36,737.66 36,737.66 28,825.00 2,187.50 4,225.16 1,500.00 0.00 Open High Risk 52,073.42 0.00 J2961 12961 12961 12961 J2961 67 0.00 23100 42300 42200 12030 42400 HST Charged On Sales Sales: Lumber Sales: Hardware Accounts Receivable Sales: Roofing liability, income_tax, ap revenue, ebitda revenue, ebitda ar, asset revenue, ebitda 2015-01-05 52,073.42 2015-01-05 customer71 - Job cancelled 5,990.08 2015-01-05 customer71 - Job cancelled 2,916.67 2015-01-05 customer71 - Job cancelled 2,000.00 2015-01-05 customer71 - Job cancelled 0.00 2015-01-05 customer71 - Job cancelled 41,166.67 0.00 52,073.42 0.00 J2961 Open High Risk 12962 J2962 42300 23100 J2962 Sales: Lumber HST Charged On Sales Sales: Hardware Accounts Receivable Sales: Roofing 12962 2015-01-05 78,110.1378,110.13 2015-01-05 customer72 - Job cancelled 4,375.00 0.00 2015-01-05 customer72 - Job cancelled 8,985.13 0.00 2015-01-05 customer72 - Job cancelled 3,000.00 0.00 2015-01-05 customer72 - Job cancelled 0.00 78,110.13 2015-01-05 customer72 - Job cancelled 61,750.00 0.00 revenue, ebitda liability, income_tax, ap revenue, ebitda ar, asset revenue, ebitda J2962 12030 42400 J2962 Open High Risk J2963 12963 J2963 J2963 4444 23100 12030 Other Income HST Charged On Sales Accounts Receivable revenue, ebitda liability, income_tax, ap ar, asset 2015-01-05 2015-01-05 Loss on customer71 2015-01-05 Unrecoverd HST 2015-01-05 customer71 110,212.99 110,212.99 97,537.500.00 12,675.490.00 0.00 110,212.99 Open High Risk J2964 J2964 J2964 J2964 4444 23100 12030 Other Income HST Charged On Sales Accounts Receivable revenue, ebitda liability, income_tax, ap ar, asset 2015-01-05 2015-01-05 Loss on customer72 2015-01-05 Unrecoverd HST 2015-01-05 customer72 36,737.66 32,512.50 4,225.16 0.00 36,737.66 0.00 0.00 36,737.66 1360 Revenue greater than $100,000 J360 1360 1360 1360 J360 1360 1360 42200 23000 44100 23100 12000 15300 50200 Sales: Hardware PST Payable Freight Revenue GST Charged on Sales Accounts Receivable Hardware Material: Hardware revenue, ebitda liability, income_tax, ap revenue, ebitda liability, income_tax, ap ar, asset asset cogs, ebitda, expense 2015-02-21 2015-02-21 International Oil 2015-02-21 International Oil 2015-02-21 International Oil 2015-02-21 International Oil 2015-02-21 International Oil 2015-02-21 International Oil 2015-02-21 International Oil 111,317.18 0.00 0.00 0.00 0.00 93,292.80 0.00 18,024.38 111,317.18 82,500.00 5,779.20 60.00 4,953.60 0.00 18,024.38 0.00 Transactions Transaction ID Account Account Description Account Tags Tasks Status Title Posted Memo Debit Credit J235 Open - December 25th transactions J235 J235 J235 J235 J235 J235 42300 42100 42200 15300 50200 23100 15200 50100 23000 15400 50300 44100 12000 Sales: Lumber Sales: Drywall Sales: Hardware Hardware Material: Hardware GST Charged on Sales Drywall Material: Drywall PST Payable Lumber Material: Lumber Freight Revenue Accounts Receivable 2014-12-25 2014-12-25 Bayswater School Board 2014-12-25 Bayswater School Board 2014-12-25 Bayswater School Board 2014-12-25 Bayswater School Board 2014-12-25 Bayswater School Board 2014-12-25 Bayswater School Board 2014-12-25 Bayswater School Board 2014-12-25 Bayswater School Board 2014-12-25 Bayswater School Board 2014-12-25 Bayswater School Board 2014-12-25 Bayswater School Board 2014-12-25 Bayswater School Board 2014-12-25 Bayswater School Board revenue, ebitda revenue, ebitda revenue, ebitda asset cogs, ebitda, expense liability, income_tax, ap asset cogs, ebitda, expense liability, income_tax, ap asset cogs, ebitda, expense revenue, ebitda ar, asset J235 6,605.96 0.00 0.00 0.00 0.00 425.99 0.00 0.00 145.31 0.00 0.00 392.00 0.00 5,642.66 6,605.96 1,800.00 283.50 2,835.00 425.99 0.00 299.61 145.31 0.00 349.55 392.00 0.00 75.00 0.00 J235 J235 J235 J235 J235 J235 Open J2949 Reporting Adjustment J2949 J2949 J2949 J2949 J2949 42400 42200 23100 42300 12030 Sales: Roofing Sales: Hardware HST Charged On Sales Sales: Lumber Accounts Receivable revenue, ebitda revenue, ebitda liability, income_tax, ap revenue, ebitda ar, asset 2014-12-25 2014-12-25 customer71 2014-12-25 customer71 2014-12-25 customer71 2014-12-25 customer71 2014-12-25 customer71 52,073.42 0.00 0.00 0.00 0.00 52,073.42 52,073.42 41,166.67 2,000.00 5,990.08 2,916.67 0.00 Open Reporting Adjustment J2950 J2950 J2950 J2950 J2950 J2950 23100 42200 42300 42400 12030 HST Charged On Sales Sales: Hardware Sales: Lumber Sales: Roofing Accounts Receivable liability, income_tax, ap revenue, ebitda revenue, ebitda revenue, ebitda ar, asset 2014-12-25 2014-12-25 customer72 2014-12-25 customer72 2014-12-25 customer72 2014-12-25 customer72 2014-12-25 customer72 78,110.13 0.00 0.00 0.00 0.00 78,110.13 78,110.13 8,985.13 3,000.00 4,375.00 61,750.00 0.00 J2951 Revenue greater than $100,000 J2951 J2951 J2951 J2951 23100 42400 42300 42200 12030 HST Charged On Sales Sales: Roofing Sales: Lumber Sales: Hardware Accounts Receivable liability, income_tax, ap revenue, ebitda revenue, ebitda revenue, ebitda ar, asset 2014-12-25 2014-12-25 customer71 2014-12-25 customer71 2014-12-25 customer71 2014-12-25 customer71 2014-12-25 customer71 110,212.99 0.00 0.00 0.00 0.00 110,212.99 110,212.99 12,675.49 86,475.00 6,562.50 4,500.00 0.00 J2951 Open December 25th transactions J2952 J2952 J2952 J2952 J2952 J2952 42400 42300 23100 42200 12030 Sales: Roofing Sales: Lumber HST Charged On Sales Sales: Hardware Accounts Receivable revenue, ebitda revenue, ebitda liability, income_tax, ap revenue, ebitda ar, asset 2014-12-25 2014-12-25 customer72 2014-12-25 customer72 2014-12-25 customer72 2014-12-25 customer72 2014-12-25 customer72 36,737.66 0.00 0.00 0.00 0.00 36,737.66 36,737.66 28,825.00 2,187.50 4,225.16 1,500.00 0.00 Open High Risk 52,073.42 0.00 J2961 12961 12961 12961 J2961 67 0.00 23100 42300 42200 12030 42400 HST Charged On Sales Sales: Lumber Sales: Hardware Accounts Receivable Sales: Roofing liability, income_tax, ap revenue, ebitda revenue, ebitda ar, asset revenue, ebitda 2015-01-05 52,073.42 2015-01-05 customer71 - Job cancelled 5,990.08 2015-01-05 customer71 - Job cancelled 2,916.67 2015-01-05 customer71 - Job cancelled 2,000.00 2015-01-05 customer71 - Job cancelled 0.00 2015-01-05 customer71 - Job cancelled 41,166.67 0.00 52,073.42 0.00 J2961 Open High Risk 12962 J2962 42300 23100 J2962 Sales: Lumber HST Charged On Sales Sales: Hardware Accounts Receivable Sales: Roofing 12962 2015-01-05 78,110.1378,110.13 2015-01-05 customer72 - Job cancelled 4,375.00 0.00 2015-01-05 customer72 - Job cancelled 8,985.13 0.00 2015-01-05 customer72 - Job cancelled 3,000.00 0.00 2015-01-05 customer72 - Job cancelled 0.00 78,110.13 2015-01-05 customer72 - Job cancelled 61,750.00 0.00 revenue, ebitda liability, income_tax, ap revenue, ebitda ar, asset revenue, ebitda J2962 12030 42400 J2962 Open High Risk J2963 12963 J2963 J2963 4444 23100 12030 Other Income HST Charged On Sales Accounts Receivable revenue, ebitda liability, income_tax, ap ar, asset 2015-01-05 2015-01-05 Loss on customer71 2015-01-05 Unrecoverd HST 2015-01-05 customer71 110,212.99 110,212.99 97,537.500.00 12,675.490.00 0.00 110,212.99 Open High Risk J2964 J2964 J2964 J2964 4444 23100 12030 Other Income HST Charged On Sales Accounts Receivable revenue, ebitda liability, income_tax, ap ar, asset 2015-01-05 2015-01-05 Loss on customer72 2015-01-05 Unrecoverd HST 2015-01-05 customer72 36,737.66 32,512.50 4,225.16 0.00 36,737.66 0.00 0.00 36,737.66 1360 Revenue greater than $100,000 J360 1360 1360 1360 J360 1360 1360 42200 23000 44100 23100 12000 15300 50200 Sales: Hardware PST Payable Freight Revenue GST Charged on Sales Accounts Receivable Hardware Material: Hardware revenue, ebitda liability, income_tax, ap revenue, ebitda liability, income_tax, ap ar, asset asset cogs, ebitda, expense 2015-02-21 2015-02-21 International Oil 2015-02-21 International Oil 2015-02-21 International Oil 2015-02-21 International Oil 2015-02-21 International Oil 2015-02-21 International Oil 2015-02-21 International Oil 111,317.18 0.00 0.00 0.00 0.00 93,292.80 0.00 18,024.38 111,317.18 82,500.00 5,779.20 60.00 4,953.60 0.00 18,024.38 0.00
