Basic Assignments
|
Options & Settings
|
Main Time Information
|
||||||||||||||||||||||
|
|
|
|
|||||||||||||||
Photo/Image Count: 14
|
|||||||||||||||
|
|||||||||||||||
|
Notes:
|
Scan 82 – Financial Tables Financial Tables: (Please see scan in photo gallery) Financial group subs table Values for financial group subs table Scan 83 – Financials – Options Options: 1. Bring the whole thing up together – balance sheet, payables, and check write system 2. Work on chart of accounts 3. Work on payables 4. Work on check write system 5. Work on balance sheet items Goal – record every penny in and out: - Owned and owed - Need a new model - And a classic model (assets, liabilities, equity) - Owned & owed Scan 84 – Financial Mapping Question: Do I need one to many, one to many, one to many, one to many? - By this point the destination and category have already been assigned - Group: - Sub group: – needs to be required - Type name: - This is much better Or Do I need sub tables and pull the one to many items together at the end? - Destination: - Category: - Group: - Sub Group: - Type Name: Scan 89 – Expense & Deposit Types Expense Types: - Ads – xxxxx - Ads – xxyy - View 1 – expense - Advertising % - Interest % - Semi Fixed % - Fixed % - People % - Total $$ - Net Deposit Types: - Type - Fixed Assets - Long Term Debt Scan 90 – Financial Destinations Destination: - Income Statement - Balance Sheet - Reimbursements Grouping: Type: 4 deep on layers - Main level: - Group: - Sub: - Type: Expense – Semi-Fixed – Utilities – light bill Assets – current assets – A/R – sales invoices Scan 93 – Financial Tables (Categories & Destinations) Financial Tables: (Please see scan in photo gallery) Money Destinations Table Values for Money Destinations Table: ID/Name: - 1 – Dummy - 2 – Balance Sheet - 3 – Income Statement Financial Categories Table Values for Financial Categories Table: ID/Name/Dest ID: - 1 – Dummy – 1 - 2 – Assets – 2 - 3 – Liabilities – 2 - 4 – Equity – 2 - 5 – Special Expenses – 2 - 6 – Special Income – 2 - 7 – Expense (normal) – 3 - 8 – Income (normal) – 3 - 9 – Cost of Sales – 3 (?) - 10 – Inventory – 3 (?) Financial Groups Table: Values for Financial Groups Table: ID/Name/Corp/Cat ID/ Status/Sort - 1 – Dummy – 1 -1 -0 – 1 - Cash/Bank Account - ? – 2 -1 -1 Scan 94 & 95 – Financial Mapping (Expense & Deposit Types) - Destination o Category • Group - Sub Group o Type - I.S. o Normal Deposit • Revenue - Normal revenue o Invoice sales - I.S. o Other Revenue (not from sales) • Revenue - Other revenue o Other Revenue (not from sales) - I.S. o Revenue Adjustment (credit card fees) • Revenue Adjustment - Revenue Adjustment Amex Fees (deposit adjustments) - I.S. o Special Deposit • Bank Transfer - Bank Transfer o Bank Transfer - B.S. o Special Deposit • Bank Transfer - Bank Transfer o Bank Transfer - B.S. o Special Deposit • Balance Sheet Items - Balance Sheet Items o Balance Sheet Items - I.S. o Normal Deposit • Aaah… - Aaah… o Not sure : ) - I.S. o Normal Expense • Aaah… - Aaah… o Not sure : ) - I.S. o Normal Expense • Advertising - Advertising - I.S. o Normal Expense • Fixed Expense - Fees - Freight - Insurance - Lease - Rent - Tax - Utilities - I.S. o Normal Expense • Interest - Interest - I.S. o Normal Expense • People - Wages - I.S. o Normal Expense • Semi-Fixed Expenses - Bank - Contributions/Donations - Food - Gas, Fuel, Oil - Lodging - Postage - Repairs - Services - Supplies - Travel - Fees - Taxes - I.S. o COGS – Cost of Goods Sold • COGS - COGS - B.S. o Special Expense • Balance Sheet Items - Balance Sheet Items o Balance Sheet Item - B.S. o Special Expense • Inventory - Inventory o Inventory - B.S. o Special Expense • Reimbursements - Reimbursements o Reimbursement Scan 96 & 97 – Financial Mapping – Categories (Expense Types) Groups/Subs/Types: Group: - Normal Expense: o Not Sure • Questions - Advertising: o Ads & Promotion • Events • Internet • Newspaper • Phone Book • Radio • Television • Magazine • Replace with name of advertising type - Interest: o Bank Loan • Replace with name of bank or person o Inventory • Replace with inventory type name • GE/TEXTRON - People % o Education • Replace with education type o Wages • Replace with wage type - Fixed Expenses o Rent • Replace with building on lot name o Insurance • Replace with insurance name or type - Normal Expenses - Semi-Fixed Expenses Scan 98 – Financial Mapping & Categories (Expense/Deposit Types) Locked: - Normal - Deposit - Special Locked: Group/Sub/Type Normal - Revenue o Revenue • Invoice (key id – I’m I.S. or B.S.) Deposit: - Medical Supply o Medicare • Area 11 • Area 7 Special: - Revenue o Medicaid • Area 7 • Area 4 Scan 99 – Financial Planning – Balance Sheet Goal – follow clear through to balance sheet: (simple) 1. Paid in capital for 3 share holders a. #1 = $400 b. #2 - $400 c. #3 = $200 2. Cost of setting up business a. Domain names - $250 b. SOS business name - $25 c. License - $150 d. Hosting - $40 3. Revenue from customers a. 2 basic - $50 b. 2 intermediate - $75 c. 4 advanced - $100 Complex: 1. Existing paid in capital - $35,000 a. Existing asset i. $4,000 - $2,000 – dep 2. Inventory Costs (PO’s) a. $2,000 – stock 17 3. Business expenses a. $100 light bill b. $50 interest c. $35 taxes 4. Loan pmt a. $1,425 lease 5. Inventory Sales a. $3,500 – stock 17 6. Sell asset a. $1,000 computer Scan 128 – Financial Categories Financial Categories: 1. Dummy 2. Assets 3. Liabilities 4. Equity 5. Special Expense 6. Special Deposit 7. Other Revenue (not from sales) 8. Cost of Sales (COGS) 9. Normal Expense 10. Normal Deposit 11. Revenue Adjustment (credit card fees) Financial Groups: 7. Other Revenue - Cash Over & Short 9. Normal Expense: - Aaah… - Interest - Advertising - People - Fixed Expenses - Semi-Fixed Expenses 5. Special Expense: - Balance Sheet Items - Reimbursements - Inventory 10. Normal Deposit - Revenue - Aaah… - Other - This could be a deposit type for Amex or a normal expense if fees are taken out later in a lump sum. Some people might want to put the expense into COGS instead of general expenses. 6. Special Deposit - Bank Transfer - Balance Sheet Items Scan 131 – Financial Category Planning Expense Types: Final Destination: 1. Dummy 2. Income Statement 3. Balance Sheet Category – group – type - Semi-Fixed – Utilities – Electric Chart of Accounts: - All existing plus Account Group ID: - Property taxes - Shipping - Pre-paid insurance - Pro-rata distributions - Payroll taxes - Receive payments - Clearing accounts - Pmt on assets - Re-purchase of investment Account Categories (Category) – Account Destinations (Main Menu) – Account Groups (Group) *REPLACED BY: Destinations, Categories, Groups & Sub Groups Other Possible Balance Sheet Items: - Get a refund on Inv. - Get a donation - Sell a company - Equipment - Pre-paid Bills - Stocks - Buy out 1 or more owners - Law suit/settlement for or against - Petty cash - Retained earnings - Trade down (upside down side) - Refunds - Stocks, Bonds, & Securities - Bad Debt - Bad Checks - Depreciation - Auto Invoicing - Auto Expenses - Internal Invoices - Floorplan - A/P with Curtailment |