Joan Gawat | Freelancer Management Reports Thru Quick Books

Management Reports thru QuickBooks

Management Report Business Overview Side Numbers Accounting Firm For the period ended 31 December 2022 Prepared by JOAN C. GAWAT Prepared on 21 July 2022 For management use only Table of Contents Profit and Loss .................................................................................................................................................3 Balance Sheet ..................................................................................................................................................4 Trial Balance ....................................................................................................................................................5 Quarterly Profit and Loss Summary .................................................................................................................6 Statement of Cash Flows .................................................................................................................................7 Statement of changes in equity........................................................................................................................8 A/R Aging Summary.........................................................................................................................................9 Sales by Product/Service Summary ..............................................................................................................10 Transaction List by Supplier...........................................................................................................................11 2/18 Profit and Loss 31 December, 2021 - 31 March, 2022 Total INCOME Sale of Service Sales of Product Income Sales or Product & Income (deleted) Total Income COST OF SALES Cost of Sales Total Cost of Sales GROSS PROFIT EXPENSES Bank charges Depreciation Expense Dues & Subscription Expense (deleted) Dues and subscriptions Fiverr Google UPWORK Total Dues and subscriptions Freight and Delivery Fuel & Lubricants Hotel Accommodation Income tax expense Insurance - General Interest expense Legal and professional fees Marketing & Advertising Meals and entertainment Miscellaneous Expense Office Supplies Online Tools Expense Other general and administrative expenses Purchases Rent expense Repairs and Maintenance Salaries Expense Stationery & Printing Supplies Expense Telephone Expense Uncategorized Expense Utilities Total Expenses NET EARNINGS Side Numbers Accounting Firm 54,-,-,-,-,-,-,-,-,-,714.84 2,-,-,-,-,260.00 2,-,275.00 1,900.00 2,-,805.98 $7,342.77 3/18 Balance Sheet As of March 31, 2022 Total ASSETS Current Assets Accounts receivable Accounts Receivable (A/R) 37,394.55 Total Accounts receivable Americas First Bank Cash and cash equivalents Inventory Prepaid Dues & Subscription Prepaid Office Rent Supplies on hand 37,394.55 -,-,- Total Current Assets Long-term assets Accu. Depreciation - Equipment Equipment 91,112.71 Total long-term assets Total Assets LIABILITIES AND SHAREHOLDER'S EQUITY Current liabilities: Accounts payable Accounts Payable (A/P) Total Accounts payable Costco Business CITI Income tax payable Salaries Payable Uneraned Consulting Fees Total current liabilities Shareholders' equity: Net Income Additional Investment Retained Earnings Share capital Total shareholders' equity Total liabilities and equity Side Numbers Accounting Firm -5,-,-,600.00 $103,712.71 17,-,-,071.00 8,-,-,-,-,000.00 -24,-,-,-,712.71 4/18 Trial Balance As of March 31, 2022 Debit Americas First Bank Cash and cash equivalents Accounts Receivable (A/R) Inventory Prepaid Dues & Subscription Prepaid Office Rent Supplies on hand Accu. Depreciation - Equipment Equipment Accounts Payable (A/P) Costco Business CITI Income tax payable Salaries Payable Uneraned Consulting Fees Additional Investment Retained Earnings Share capital Sale of Service Sales of Product Income Cost of Sales Bank charges Dues and subscriptions Dues and subscriptions:Fiverr Dues and subscriptions:Google Dues and subscriptions:UPWORK Freight and Delivery Fuel & Lubricants Hotel Accommodation Insurance - General Interest expense Legal and professional fees Marketing & Advertising Meals and entertainment Office Supplies Online Tools Expense Other general and administrative expenses Purchases Repairs and Maintenance Stationery & Printing Uncategorized Expense Utilities TOTAL Side Numbers Accounting Firm Credit 245.92 24,-,-,-,-,-,-,071.00 8,-,-,-,-,-,-,-,-,714.84 2,-,-,600.00 1,900.00 2,735.55 $174,358.01 $174,358.01 5/18 Quarterly Profit and Loss Summary 31 December, 2021 - 31 March, 2022 31 Dec, 2021 INCOME Sale of Service Sales of Product Income Sales or Product & Income (deleted) Total Income Jan - Mar, 2022 Total 54,-,634.90 54,-,-,170.69 77,385.38 143,556.07 19,407.32 19,407.32 0.00 19,407.32 19,407.32 66,170.69 57,978.06 124,148.75 165.24 165.24 3,- 66,-,170.69 COST OF SALES Cost of Sales Total Cost of Sales GROSS PROFIT EXPENSES Bank charges Depreciation Expense Dues & Subscription Expense (deleted) Dues and subscriptions Fiverr Google UPWORK Total Dues and subscriptions Freight and Delivery Fuel & Lubricants Hotel Accommodation Income tax expense Insurance - General Interest expense Legal and professional fees Marketing & Advertising Meals and entertainment Miscellaneous Expense Office Supplies Online Tools Expense Other general and administrative expenses Purchases Rent expense Repairs and Maintenance Salaries Expense Stationery & Printing Supplies Expense Telephone Expense Uncategorized Expense Utilities Total Expenses NET EARNINGS Side Numbers Accounting Firm 3,- 1,900.00 2,735.55 -,-,714.84 2,-,-,-,-,260.00 2,-,275.00 1,900.00 2,735.55 95,540.00 21,265.98 116,805.98 $ -29,369.31 $36,712.08 $7,342.77 28,- -,714.84 2,- 4,-,-,-,260.00 2,-,275.00 6/18 Statement of Cash Flows 31 December, 2021 - 31 March, 2022 Total CASH FLOWS FROM OPERATING ACTIVITIES Profit for the year Adjustments for non-cash income and expenses: Accounts Receivable (A/R) Inventory Prepaid Dues & Subscription Prepaid Office Rent Supplies on hand Accu. Depreciation - Equipment Accounts Payable (A/P) Costco Business CITI Income tax payable Salaries Payable Uneraned Consulting Fees Total Adjustments for non-cash income and expenses: Net cash from operating activities CASH FLOWS FROM INVESTING ACTIVITIES Equipment Net cash used in investing activities CASH FLOWS FROM FINANCING ACTIVITIES Additional Investment Retained Earnings Share capital Net cash used in financing activities NET INCREASE (DECREASE) IN CASH AND CASH EQUIVALENTS Cash and cash equivalents at beginning of year CASH AND CASH EQUIVALENTS AT END OF YEAR Side Numbers Accounting Firm 7,342.77 -37,394.55 -28,989.08 -100.00 -100.00 -225.00 5,-,-,007.60 8,-,550.00 -17,560.32 -10,217.55 -18,000.00 -18,-,000.00 5,-,-,-,897.45 -593.37 $24,304.08 7/18 Statement of changes in equity As of March 31, 2022 Total Additional Investment Retained Earnings Share capital Total Equity Side Numbers Accounting Firm 13,000.00 -24,-,-,088.92 8/18 A/R Aging Summary As of March 24, 2022 Current Cole Woodman David Anderson Erin Johnson Katharina Salmen TOTAL Side Numbers Accounting Firm 1 - 30 31 - 60 61 - 90 91 and over 4,481.90 4,-,600.00 8,- 23,600.00 8,- $0.00 $32,306.30 $5,088.25 Total $0.00 $0.00 $37,394.55 9/18 Sales by Product/Service Summary 31 December, 2021 - 31 March, 2022 Total Accounting Services Acer Aspire 3 A315-31 Black App Development Asus MeMO Pad Backend development Dell Inspiron 17 2in1 (7779) Silver Dell Latitude 5280 Front end development Hewlett Packard Spectre 13-v106na Dark Ash Silver IdeaTab A3500L Inspiron 15 IOS Development iPad Mini Retina Lenovo IdeaPad Miix 510 Platinum Silver Lenovo Legion Y520 Lenovo Legion Y520-15IKBM Lenovo ThinkPad E31-80 Lenovo V110-15IAP Lenovo V510 Black Lenovo Yoga 910 Grey Toshiba Portege X30-D-10J Black/Blue Not Specified TOTAL Side Numbers Accounting Firm Quantity Amount % of Sales Avg Price COS Gross Margin Gross Margin % - 5,800.00 1,761.66 6,-,000.00 1,686.30 1,-,200.48 1,-,237.98 6,750.00 1,613.97 1,818.24 1,700.87 1,-,-,799.60 1,-,000.00 6.41697% 1.94905% 6.63824% 0.17092% 21.0211% 1.86568% 1.82993%-% 2.11281% 0.44306% 2.47604% 7.46802% 1.78565% 2.01165% 1.8818% 1.84695% 0.67085% 1.18324% 0.82685% 1.99103% 1.99714%-% 5,- 1,174.44 587.22 -% 102.99 51.50 -% 1,520.00 1,102.66 - 9.86183%-% 1,-,491.98 - -%-%-% 1,075.98 1,-,-,500.00 1,199.73 1,203.41 - -4,- -%-% $90,385.38 100.00% 154.49 4,750.00 1,686.30 1,653.99 5,-,-,118.99 6,-,818.24 1,700.87 1,-,799.60 1,805.12 -%-%-% -%-%-% $19,407.32 10/18 Transaction List by Supplier 31 December, 2021 - 31 March, 2022 Date Transaction Type No. Posting Memo/Description Account Amount 01/12/2022 Purchase Order 1001 No Accounts Payable (A/P) 10,124.75 01/14/2022 Bill Yes Accounts Payable (A/P) 7,994.32 01/31/2022 Bill Payment (Check) 3 Yes Americas First Bank -7,994.32 01/05/2022 Purchase Order 1002 No Accounts Payable (A/P) 10,650.00 01/10/2022 Bill Yes Accounts Payable (A/P) 7,400.00 01/11/2022 Supplier Credit Yes Accounts Payable (A/P) -500.00 Aaron Simpson Alex Petersen Americas First Bank 01/05/2022 Expense Yes AUTOMATIC WITHDRAWAL, Bank Charges Americas First Bank -45.65 01/28/2022 Expense Yes AUTOMATIC WITHDRAWAL, Bank Charges Americas First Bank -100.00 Yes AUTOMATIC WITHDRAWAL, Atlassian Pty Americas First Bank -100.00 Atlassian Pty 01/19/2022 Expense Brandon Williams Side Numbers Accounting Firm 11/18 Date Transaction Type No. Posting 01/08/2022 Purchase Order 1003 No Accounts Payable (A/P) 6,239.95 01/08/2022 Bill Yes Accounts Payable (A/P) 6,546.76 01/17/2022 Supplier Credit Yes Accounts Payable (A/P) -177.98 01/31/2022 Bill Payment (Check) Yes Americas First Bank -6,546.76 Accounts Payable (A/P) 15,000.00 4 Memo/Description Account Amount Brian Miller 01/18/2022 Bill Yes For employee's use 01/21/2022 Bill Payment (Check) Yes Americas First Bank No Accounts Payable (A/P) 5,065.70 3,753.71 -15,000.00 Brian Renner 01/08/2022 Purchase Order 1005 01/08/2022 Bill Yes Accounts Payable (A/P) Expense Yes Americas First Bank No Accounts Payable (A/P) Bruce Nelson 01/12/2022 -8,473.46 Bruce Powell 01/08/2022 Purchase Order 1004 6,653.04 Burger King 01/14/2022 Expense Side Numbers Accounting Firm Yes AUTOMATIC WITHDRAWAL, Burger King Americas First Bank -100.00 12/18 Date Transaction Type No. Posting Memo/Description Account Amount -300.00 Carlos Gianfelice 01/13/2022 Expense Yes Americas First Bank Bill Yes Accounts Payable (A/P) Expense Yes Americas First Bank -222.15 Caset Potter 01/18/2022 7,464.98 Cathy Ellason 01/17/2022 Charles Zitting 01/12/2022 Check Expense 1 Yes Americas First Bank -295.00 Check Expense 5 Yes Americas First Bank -219.89 Purchase Order 1007 No Accounts Payable (A/P) 01/03/2022 Check Expense 2 Yes Americas First Bank -1,000.00 01/03/2022 Check Expense 6 Yes Americas First Bank -1,000.00 Clark Kimball 01/12/2022 Clark Ward 01/31/2022 3,000.00 Clint Phillips Side Numbers Accounting Firm 13/18 Date Transaction Type No. Posting Memo/Description Account Amount Comcast Cable Comm 01/04/2022 Expense Yes Costco Business CITI No Accounts Payable (A/P) 100.00 Cornerstone Construction & Renovation 01/03/2022 Purchase Order 1006 3,000.00 Costco gas 01/03/2022 Expense Yes COSTCO GAS #0733 LEHI UT Costco Business CITI 65.66 01/11/2022 Bill Yes Accounts Payable (A/P) 01/12/2022 Bill Payment (Check) Yes Americas First Bank 01/27/2022 Bill Yes Accounts Payable (A/P) 01/27/2022 Bill Payment (Check) Yes Americas First Bank -2,500.00 Dale Butler 1,000.00 -1,000.00 Dave Morley 2,500.00 Enviroclean USA LLC 01/18/2022 01/24/2022 Expense Expense Side Numbers Accounting Firm Yes AUTOMATIC WITHDRAWAL, Enviroclean USA LLC Americas First Bank -65.00 Yes AUTOMATIC WITHDRAWAL, Enviroclean USA LLC Americas First Bank -725.00 14/18 Date Transaction Type 01/24/2022 No. Posting Memo/Description Account Amount Expense Yes AUTOMATIC WITHDRAWAL, Enviroclean USA LLC Americas First Bank -455.55 01/01/2022 Expense Yes Fiverr- NY Costco Business CITI 38.93 01/02/2022 Expense Yes Fiverr- NY Costco Business CITI 73.85 01/03/2022 Expense Yes Costco Business CITI 368.20 Expense Yes GOOGLE GSUITE_dgibuild.c- CA Costco Business CITI 22.58 GOOGLE *SVcSdgibuild.c g.co/HelpPay#CA Costco Business CITI 13.32 Costco Business CITI -18.25 Fiverr Google 01/01/2022 01/02/2022 Expense Yes 02/05/2022 Credit Card Credit Yes Expense Yes AUTOMATIC WITHDRAWAL, Hilton Hotels Americas First Bank -532.00 Expense Yes AUTOMATIC WITHDRAWAL, Hubstaff Americas First Bank -240.00 Hilton Hotels 01/10/2022 Hubstaff 01/18/2022 LexisNexis Legal & Professional Side Numbers Accounting Firm 15/18 Date Transaction Type 01/31/2022 Expense 01/31/2022 Posting Memo/Description Account Amount Yes AUTOMATIC WITHDRAWAL, LexisNexis Legal & Professional Americas First Bank -689.20 Yes AUTOMATIC WITHDRAWAL, LexisNexis Legal & Professional Americas First Bank -391.80 Expense Yes AUTOMATIC WITHDRAWAL, Meralco Water & Electricity Americas First Bank -500.00 Expense Yes AUTOMATIC WITHDRAWAL, Mercury Drug (First Aid Kit) Americas First Bank -139.99 Americas First Bank -376.00 Expense No. Meralco Water & Electricity 01/10/2022 Mercury Drug 01/11/2022 MLH Consular Consulting 01/26/2022 Expense Yes AUTOMATIC WITHDRAWAL, MLH Consular Consulting 01/31/2022 Expense Yes AUTOMATIC WITHDRAWAL, MLH Consular Consulting Americas First Bank -257.84 Expense Yes AUTOMATIC WITHDRAWAL, PAYPAL Merchant Charges Americas First Bank -19.59 Paypal 01/12/2022 Selecthealth Side Numbers Accounting Firm 16/18 Date Transaction Type 01/01/2022 Expense No. Posting Memo/Description Account Amount Yes SELECTHEALTH ID B- UT Costco Business CITI 81.08 Expense Yes SIDE CAR CAFE SPRINGVILLE UT Costco Business CITI 29.84 Expense Yes AUTOMATIC WITHDRAWAL, Slack Americas First Bank Yes SPARE SPACE STORAGE-SP- UT Costco Business CITI 70.00 Expense Yes THE HOME DEPOT #4417 AMERICAN FORKUT Costco Business CITI 52.53 Credit Card Credit Yes Costco Business CITI -85.00 SIDE CAR CAFE 01/04/2022 Slack 01/03/2022 -300.00 Spare Space Storage 01/04/2022 Expense THE HOME DEPOT 01/03/2022 Tmobile 01/08/2022 TRAVELERS PERS INSURANCE Side Numbers Accounting Firm 17/18 Date Transaction Type 01/03/2022 No. Posting Memo/Description Account Amount Expense Yes TRAVELERS PERS INS- CT Costco Business CITI 01/03/2022 Expense Yes UPWORK Costco Business CITI 3.00 01/04/2022 Expense Yes UPWORK Costco Business CITI 4.00 01/04/2022 Expense Yes UPWORK Costco Business CITI 1.00 57.00 UPWORK Side Numbers Accounting Firm 18/18