FORD OF CANADA FORD OF MEXICO 2021 - Ford Motor Company
DEALERSHIP FINANCIAL STATEMENTEDIT ERROR CODESFORFORD DIVISIONLINCOLN DIVISIONFORD OF CANADAFORD OF MEXICO2021EDITIONTHE INFORMATION CONTAINED WITHIN THIS GUIDE IS FOR USE BYDEALERSHIPS UTILIZING ELECTRONIC SUBMISSION SOFTWAREFOR FINANCIAL STATEMENT REPORTING(EFFECTIVE WITH JANUARY, 2021 DATA)BUSINESS MANAGEMENT DEPARTMENT
20210130PERIOD OFDEALER3MONEY MARKET/DEPOSITFINANCE CONTRACTSNEWUSED45MARKETABLE SECURITIES6NOTES RECEIVABLE7Discounted Notes Receivable (NON US)00508VEHICLE9PARTS SERVICE BODYACCOUNTS RECEIVABLE10111213141516XXXXXON HAND IN CE SHEET00010002000300040005B01G20 (B02 XB03B04INCOME TAX REFUNDFO W&P CLAIMSR VEHICLE HOLDBACKDINCENTIVESXFordR LincolnB2700630064 B28CSR (FoC)SupportSupportEC JOBBER INCENTIVES/ESP/FLOOR PLAN E TRUCKSWNON CPOUSEDCPO(FranchiseOnly)28 PARTS 2B140089CARS0097FOMOCO009930 OTHER 9004000410042004300440045004646 CASH VALUE - LIFE INSURANCE004747 OTHER ASSETS - NET004848 TOTAL ASSETS510031003845 RECEIVABLES - OFFICER & EMPLOYEES500030003744 FINANCE RECEIVABLES DEFERRED NET49FROZEN CAPITALJ08OVERDRAFT/LINES OF CREDIT (LINE OF CREDIT LIMIT)J09ACCOUNTS PAYABLEJ10ACCOUNTS PAYABLE - CUSTOMER SALES TAXJ16INCOME TAXESJ11CUSTOMERJ12J13ACCRUEDJ19J20)J21 B20J14 B585556VEHICLE EQUITY USEDJ26 B25J27 B26J28 B49J29J30J31J32TOTAL02290230023102320233TOTAL LIABILITIES0234CAPITAL STOCKCORPORATION0235RETAINED EARNINGSJ76J77J78J79J80J81J82B37TREASURY STOCKJ38FIXED ASSET REVALUATION (NON US))))J44SUB SJ84J860237J37J430236CAPITAL IN EXCESS OF STOCK PAR VALUEJ36J42J75NETWORTH0238(DIVIDENDS DECLAREDPARTNERS' ORINVESTMENTPROPRIETOR'SDRAWING(NET INVESTMENT0239024002410242J88 G27J89J90J91J45TOTAL LIABILITIES & NET WORTHJ46RETURN ON INVESTMENT - ROIJ47WORKING CAPITALB34 B41ACTUAL0245B40 B41RECOMMENDED MINIMUM OR GUIDEACCOUNTS RECEIVABLE AGINGMONTH% TOTAL SALESYTDVEH ACCTSPARTS ACCTSSERVICE ACCTEXPENSEBODY ACCTS57 OPERATING PROFITWARR RECV58 ADD/DED TO INCOME - BONUSESFORD INCENT59NOTES RECPROFIT BEFORE INCOME TAXSTOP STATEMENT FROM BEING SUBMITTED)0244NET WORTHACTUAL OVER(UNDER)YTD)B390243NET PROFIT - AFTER INCOME TAX - YTDGROSSRED HILIGHTED AREAS WILL0228OTHEROTHER LIABILITIESB31J41J68 G24B350227FORDRENTAL VEHICLESJ35J40J670226J33J39J97J66 G230225ESTIMATED LIABILITY-REPOSSESSION PURCHASE LOSS))J60NETCASHLEASED VEHICLES)J590221OFFICERS & OWNERSNOTESPAYABLEJ56J650218MORTGAGES PAYABLELONGTERMLIABILITIESJ550216XJ15 B59J54J6402190220J53 B4302150217TOTAL CURRENT LIABILITIESJ57 B44J630214DEFERRED INTEREST INCOME (CURR PORTION - NON US)J52 B42J620213OTHERJ51J610212XXPROFIT SHARING (NON US)CURRENTSALES0403DEPOSITSPSB RECEIVABLES540210TAXESJ17USED VEHICLE INVENTORYMONTH0209PAYROLL & BONUSES(negative amount no frozen capital PARTS INVENTORYfor dealership)OPERATING ANALYSISX0208ACCOMMODATIONS-SVC CONTRACTS/REP REFUND525302060211NET CASH OVER (UNDER)00290205LONG TERM - CURRENT PORTIONJ25 B240036DEPRECIATION42)0204OTHER - SHORT TERMAVERAGE MONTH TOTAL EXPENSES0035TRUCK '0103DEPRECIATIONEQUIPMENTJ070203RECREATION VEHICLESNET CASH0034BUILDINGSJ050401REMARKETED VEHICLESJ24 B230028(CAR '0102J040202CPO VEHICLES (FRANCHISE ONLY)J23 B220027NON FOMOCOUSEDJ030201USED VEHICLES - NON CPOJ22 B21 NEW0026MEMO: WORK IN PROCESS'0100PNAOYTAEBSLE0022030260DAYSJ02J06XNEW VEHICLES & DEMOS0023030137 LAND AND IMPROVEMENTS NET4000210025PARTSUNITS:0020002436 RENTAL VEHICLES NET380015001734 TOTAL CURRENT ASSETSLEASED VEHICLES NET0010001333 PREPAID EXPENSES350009LIABILITIESJ01001429 ALLOWANCE - PARTS INVENTORY ADJUSTMENT31 LIFO 2B2918 ALLOWANCE - DOUBTFUL RECEIVABLE19 N CARS0006001117 FINANCE RECEIVABLE CURRENT20SALES CODE0132CITY STATE ZIP CODEASSETSCASH0131REC'DADDRESSMONTH ENDED12021FORD MOTOR COMPANY DEALER FINANCIAL STATEMENTG14G100129P&A 72B73B74B7091 0521052205230524052505260527B71B72B72B72B73B74B70
Edit Changes Page 1NO CHANGES
PAGE 1 EDIT ERROR EXPLANATIONSG02W1DEALER IS REPORTING FOR THE FIRST TIME THIS YEARVERIFY "PERIOD OF" (BUCKET 130) IS CORRECT AND SUBMIT AN OVERRIDE.G03W1PERIOD OF (BUCKET 130) CALCULATED FROM LAST REPORTED MONTH SHOULD BE XXXG05W1RECORD CODE UNACCEPTABLE BUCKET 132FIRST FOUR POSITIONS OF RECORD INVALIDG06W1MONTH CODE INVALIDA - JANUARYB - FEBRUARYC - MARCHD - APRILE - MAYF - JUNEG07W1STATEMENT RECEIVED FOR INACTIVE CODE BUCKET 132 OR BUCKET 129STATEMENT DROPPEDG10W1INVALID "PERIOD OF"- BUCKET 130. Period of doesn't match month ended posted on statementG14W1P & A CODE (BUCKET 129) FOR THE DEALER IS DIFFERENT THAN THE P & A CODE ON THE FINANCIALSTATEMENT. CHECK DCS DOWNLOAD FILE TO VERIFY P & A CODE IS POSTED CORRECTLY(5 DIGIT NUMBER EXAMPLE 582 00582)G20SS1DISCOUNTED NOTES RECEIVABLE (NON US) BUCKET 0007 HAS AN INVALID VALUE.BUCKET 0007 NOT EQUAL 0 USA DEALERS CANNOT USEG21SS1DISCOUNT NOTES RECEIVABLE (NON US) PAST DUE BUCKET 0051 HAS AN INVALID VALUE.BUCKET 0051 NOT EQUAL 0 USA DEALERS CANNOT USEG23SS1PROFIT SHARING (NON US) BUCKET 0216 HAS INVALID VALUE. BUCKET 0216 NOT EQUAL 0 USA DEALERS CANNOT USEG24SS1DEFERRED INTEREST INCOME (NON US) BUCKET 0218 HAS INVALID VALUE.BUCKET 0218 NOT EQUAL 0 USA DEALERS CANNOT USEG27SS1FIXED ASSET REVALUATION (NON US) BUCKET 0238 HAS INVALID VALUE. BUCKET 0238 NOT EQUAL 0USA DEALERS CANNOT USEB-01W1Past due Notes Receivable Bucket 50 exceeds total Bucket 6. Notes receivable totals need to be more thanPast due amount. Check to see that Notes Receivable amount includes past due memo amount.B-02W1Past due Accounts Receivable Vehicle Bucket 52 exceeds total Bucket 8. Accounts receivable totals need tobe more than past due amount. Check to see that Accounts Receivable amount includes past due memo amountB-03W1Past due Accounts Receivable P, S & B Bucket 53 exceeds total Bucket 9. Past due accounts receivabletotals need to be more than past due amount. Check to see that Receivable amount includes pastdue memo amount.B-04W1Past due Accounts Receivable Other Bucket 54 exceeds total Bucket 10. Past due accounts receivabletotals need to be more than past due amount. Check to see that Receivable amount includes pastdue memo amount.B-05SS1New car inventory dollars Bucket 21 and zero unit inventory Sum of Buckets 80, 81 and 82 or Vice Versa. Show unitcount if dollar inventory amount shows or show dollar amount if units are shown. MUST Enter New car unit countor dollars.B-06SS1New truck inventory dollars Bucket 22 and zero unit inventory Sum of Buckets 83, 84 and 85 or Vice Versa. . Show unitcount if dollar inventory amount shows or show dollar amount if units are shown. MUST Enter New truck unit counts.or dollars.B-07SS1Demo inventory dollars Bucket 23 and zero unit inventory Sum of Buckets 86, 87 and 88 or Vice Versa. Show unitcount if dollar inventory amount shows or show dollar amount if units are shown. MUST Enter Demo unit countor dollars.B-08SS1Used car - Non CPO inventory dollars Bucket 24 and zero unit inventory Bucket 89 or Vice Versa. Show unit count ifdollar inventory amount shows or show dollar amount if units are shown. MUST Enter Used car unit count.or show dollars amount if units are shown.B-09SS160 day used car unit inventory Bucket 90 exceeds total unit inventory Bucket 89. Used car unit total MUST bemore than 60 day stock. Check to see that total unit inventory includes 60 day units (memo only).B-10SS1Used truck - Non CPO inventory dollars Bucket 25 and zero unit inventory Bucket 91 or Vice Versa. MUST show unit count ifG - JULYH - AUGUSTJ - SEPTEMBERK - OCTOBERL - NOVEMBERM - DECEMBERW WARNING CHECK TO MAKE SURE CORRECT, WILL NOT KEEP DEALER FROM SUBMITTINGSS SHOW STOPPER CANNOT SUBMIT WITHOUT CORRECTION
PAGE 1 EDIT ERROR EXPLANATIONSdollar inventory amount shows or show dollar amount if units are shown. MUST Enter Used truck unit countor dollars.B-11SS160 day used truck unit inventory Bucket 92 exceeds total unit inventory Bucket 91. Used truck unit total MUSTbe more than 60 day stock. Check to see that total unit inventory includes 60 day units (memo only).B-16SS1Used car CPO (Franchise Only) inventory dollars Bucket 301 and zero unit inventory Bucket 110 or Vice Versa.Show unit count if dollar inventory amount shows or show dollar amount if units are shown. MUST Enter Used car unit countor show dollars amount if units are shown.B-19SS1Used truck CPO (Franchise Only) inventory dollars Bucket 302 and zero unit inventory Bucket 111 or Vice Versa.Show unit count if dollar inventory amount shows or show dollar amount if units are shown. MUST Enter Used car unit countor show dollars amount if units are shown.B-12SS1Used remarketed car inventory dollars Bucket 26 and zero unit inventory Bucket 93 or Vice Versa. MUST show unit count ifdollar inventory amount shows or show dollar amount if units are shown. MUST Enter Used remarketed car unit countor dollars.B-13SS160 day used remarketed car unit inventory Bucket 95 exceeds total unit inventory Bucket 93. Usedremarketed car unit total MUST be more than 60 day stock. Check to see that total unit inventory includes 60day units (memo only).B-14SS1Used remarketed truck inventory dollars Bucket 27 and zero unit inventory Bucket 94 or Vice Versa. MUST show unit count ifdollar inventory amount shows or show dollar amount if units are shown. . MUST Enter Used remarketed truck unit countor dollars.B-15SS160 day used remarketed truck unit inventory Bucket 96 exceeds total unit inventory Bucket 94. Usedremarketed truck unit total MUST be more than 60 day stock. Check to see that total unit inventory includes60 day units (memo only).B-20W1New car inventory dollars Bucket 21 divided by total units Sum of Buckets 80, 81 and 82 is less than 5,000or more than 80,000. Verify unit count and inventory dollar amount.B-21W1New truck inventory dollars Bucket 22 divided by total units Sum of Buckets 83, 84 and 85 is less than 8,000or more than 80,000. Verify unit count and inventory dollar amount.B-22W1Demo inventory dollars Bucket 23 divided by units Sum of Buckets 86, 87 and 88 is less than 5,000 or morethan 80,000. Verify unit count and inventory dollar amount.B-23W1Used car - Non CPO inventory dollars Bucket 24 divided by units Bucket 89 is less than 50 or more than 50,000.Verify unit count and inventory dollar amount.B-24W1Used truck - Non CPO inventory dollars Bucket 25 divided by units Bucket 91 is less than 50 or more than 50,000.Verify unit count and inventory dollar amount.B-58W1Used Car CPO (Franchise Only) inventory dollars Bucket 301 divided by units Bucket 110 is less than 50 or more than 50,000.Verify unit count and inventory dollar amount.B-59W1Used Truck CPO (Franchise Only) inventory dollars Bucket 302 divided by units Bucket 111 is less than 50 or more than 50,000.Verify unit count and inventory dollar amount.B-25W1Remarketed used car inventory dollars Bucket 26 divided by units Bucket 93 is less than 5,000 or more than 35,000. Verify unit count and inventory dollar amount.B-26W1Remarketed used truck inventory dollars Bucket 27 divided by units Bucket 94 is less than 10,000 or morethan 40,000. Verify unit count and inventory dollar amount.B-27SS1Receivable for Lincoln Support bucket 0063 has aninvalid dollar amount posted, Lincoln Support has balance less than zero. Cannot enter negative numbers.Cannot submit without correctionsB-28SS1Receivable for Ford Support bucket 0064 has an invalid dollar amount posted.Ford Support has a balance less than zero. Cannot enter negative numbers.Dollars received Must be posted to Ford Support account 9440.Cannot submit without correctionsB-29SS1US dealers cannot use. Receivable for CSR (FoC) bucket 0065 has an invalid dollar amount posted.CSR (FoC) has a balance less than zero. Cannot enter negative numbers.Dollars received Must be posted to Customer Service Recognition (FoC) account 9620.Cannot submit without correctionsB-31SS1TOTAL CURRENT ASSETS OUT OF BALANCE (WITHIN /- 10) 1 8 14 24- 29W WARNING CHECK TO MAKE SURE CORRECT, WILL NOT KEEP DEALER FROM SUBMITTINGSS SHOW STOPPER CANNOT SUBMIT WITHOUT CORRECTION
PAGE 1 EDIT ERROR EXPLANATIONS 2 3 4 5 6-7B-34B-35B-37B39B40SSSSSSSSSS11111 9 10 15 11 12 13TOTAL ASSETS OUT OF BALANCE (WITHIN /- 10) 34- 39 35 40 36- 41 37 42 38- 43 17 19- 20 21 22 23 25 301 302 26 27 28 30- 31- 32 33COMPARED TO BUCKET 34 44 45 46 47TOTAL CURRENT LIABILITIES OUT OF BALANCE (WITHIN /- 10) 201 205 211 216 202 206 212 217 401 209 213 218 203 210 214 204 403 215TOTAL LIABILITIES OUT OF BALANCE (WITHIN /- 10) 219 229 225 230 226 231 227 232 228NET INVESTMENT OUT OF BALANCE (WITHIN /- 10) 234 237 240 236 238- 241 235- 239TOTAL LIABILITIES AND NET WORTH OUT OF BALANCE (WITHIN /- 10) 233 242 243COMPARED TO BUCKET 48COMPARED TO BUCKET 219COMPARED TO BUCKET 233COMPARED TO BUCKET 242COMPARED TO BUCKET 245B41SS1TOTAL ASSETS VERSUS TOTAL LIABILITIES AND NET WORTH OUT OF BALANCE MORE THAN 100BUCKET 48 COMPARED TO BUCKET 245 ( /- 100)J01SS1CANNOT SEND A CREDIT BALANCE FOR CASH ON HAND. BUCKET 1 SHOWING LESS THAN ZERO. MUST SHOW A DEBIT BALANCE.J02SS1CANNOT SEND A CREDIT BALANCE FOR MONEY MARKET DEPOSITS. BUCKET 2 SHOWING LESS THAN ZERO.MUST SHOW A DEBIT BALANCE.J03SS1CANNOT SEND A CREDIT BALANCE FOR FINANCE CONTRACTS NEW. BUCKET 3 SHOWING LESS THAN ZERO.MUST SHOW A DEBIT BALANCE.J04SS1CANNOT SEND A CREDIT BALANCE FOR FINANCE CONTRACTS USED. BUCKET 4 SHOWING LESS THAN ZERO.MUST SHOW A DEBIT BALANCE.J05SS1CANNOT SEND A CREDIT BALANCE FOR MARKETABLE SECURITIES. BUCKET 5 SHOWING LESS THAN ZERO.MUST SHOW A DEBIT BALANCE.J06SS1CANNOT SEND A CREDIT BALANCE FOR NOTES RECEIVALBE. BUCKET 6 SHOWING LESS THAN ZERO.MUST SHOW A DEBIT BALANCE.J07SS1CANNOT SEND A DEBIT BALANCE FOR DISCOUNTED NOTES RECEIVALBE (NON US). BUCKET 7 SHOWING LESS THAN ZERO.MUST SHOW A CREDIT BALANCE.J08SS1CANNOT SEND A CREDIT BALANCE FOR ACCOUNTS RECEIVABLE VEHICLE. BUCKET 8 SHOWING LESS THAN ZERO.MUST SHOW A DEBIT BALANCE.J09SS1CANNOT SEND A CREDIT BALANCE FOR ACCOUNTS RECEIVABLE P, S, B. BUCKET 9 SHOWING LESS THAN ZERO.MUST SHOW A DEBIT BALANCE.J10SS1CANNOT SEND A CREDIT BALANCE FOR ACCOUNTS RECEIVABLE OTHER. BUCKET 10 SHOWING LESS THAN ZERO.MUST SHOW A DEBIT BALANCE.W WARNING CHECK TO MAKE SURE CORRECT, WILL NOT KEEP DEALER FROM SUBMITTINGSS SHOW STOPPER CANNOT SUBMIT WITHOUT CORRECTION
PAGE 1 EDIT ERROR EXPLANATIONSJ16SS1CANNOT SEND A CREDIT BALANCE FOR ACCOUNTS RECEIVABLE INCOME TAX REFUND. BUCKET 15 SHOWING LESS THAN ZERO.MUST SHOW A DEBIT BALANCE.J11SS1CANNOT SEND A CREDIT BALANCE FOR FORD RECEIVABLE W&P. BUCKET 11 SHOWING LESS THAN ZERO.MUST SHOW A DEBIT BALANCE.J12SS1CANNOT SEND A CREDIT BALANCE FOR FORD RECEIVABLE VEHICLE HOLDBACK. BUCKET 12 SHOWING LESS THAN ZERO.MUST SHOW A DEBIT BALANCE.J13SS1CANNOT SEND A CREDIT BALANCE FOR FORD RECEIVABLE INCENTIVES. BUCKET 13 SHOWING LESS THAN ZERO.MUST SHOW A DEBIT BALANCE.J17SS1CANNOT SEND A CREDIT BALANCE FOR FORD RECEIVABLE JOBBER INCENTIVES/ESP/FLOOR PLAN ASSIST/OTHER.BUCKET 17 SHOWING LESS THAN ZERO. MUST SHOW A DEBIT BALANCE.J19SS1CANNOT SEND A CREDIT BALANCE FOR FINANCE RECEIVALBE CURRENT. BUCKET 19 SHOWING LESS THAN ZERO.MUST SHOW A DEBIT BALANCE.J20SS1CANNOT SEND A DEBIT BALANCE FOR ALLOWANCE DOUBTFUL RECEIVABLE. BUCKET 20 SHOWING LESS THAN ZERO.MUST SHOW A CREDIT BALANCE.J21SS1CANNOT SEND A CREDIT BALANCE FOR INVENTORY - NEW CARS. BUCKET 21 SHOWING LESS THAN ZERO.MUST SHOW A DEBIT BALANCE.J22SS1CANNOT SEND A CREDIT BALANCE FOR INVENTORY - NEW TRUCKS. BUCKET 22 SHOWING LESS THAN ZERO.MUST SHOW A DEBIT BALANCE.J23SS1CANNOT SEND A CREDIT BALANCE FOR INVENTORY - NEW DEMOS. BUCKET 23 SHOWING LESS THAN ZERO.MUST SHOW A DEBIT BALANCE.J24SS1CANNOT SEND A CREDIT BALANCE FOR INVENTORY - USED CARS NON CPO. BUCKET 24 SHOWING LESS THAN ZERO.MUST SHOW A DEBIT BALANCE.J25SS1CANNOT SEND A CREDIT BALANCE FOR INVENTORY - USED TRUCKS NON CPO. BUCKET 25 SHOWING LESS THAN ZERO.MUST SHOW A DEBIT BALANCE.J14SS1CANNOT SEND A CREDIT BALANCE FOR INVENTORY - USED CARS CPO. BUCKET 301 SHOWING LESS THAN ZERO.MUST SHOW A DEBIT BALANCE.J15SS1CANNOT SEND A CREDIT BALANCE FOR INVENTORY - USED TRUCKS CPO. BUCKET 302 SHOWING LESS THAN ZERO.MUST SHOW A DEBIT BALANCE.J26SS1CANNOT SEND A CREDIT BALANCE FOR INVENTORY - REMARKETED CARS. BUCKET 26 SHOWING LESS THAN ZERO.MUST SHOW A DEBIT BALANCE.J27SS1CANNOT SEND A CREDIT BALANCE FOR INVENTORY - REMARKETED TRUCKS. BUCKET 27 SHOWING LESS THAN ZERO.MUST SHOW A DEBIT BALANCE.J28SS1CANNOT SEND A CREDIT BALANCE FOR PARTS INVENTORY. BUCKET 28 SHOWING LESS THAN ZERO.MUST SHOW A DEBIT BALANCE.J29SS1CANNOT SEND A DEBIT BALANCE FOR ALLOWANCE - PARTS INVENTORY ADJ. BUCKET 29 SHOWING LESS THAN ZERO.MUST SHOW A CREDIT BALANCE.J30SS1CANNOT SEND A CREDIT BALANCE FOR OTHER INVENTORIES. BUCKET 30 SHOWING LESS THAN ZERO.MUST SHOW A DEBIT BALANCE.J31SS1CANNOT SEND A DEBIT BALANCE FOR LIFO INVENTORY RESERVE NEW & USED. BUCKET 31 SHOWING LESS THAN ZERO.MUST SHOW A CREDIT BALANCE.J32SS1CANNOT SEND A DEBIT BALANCE FOR LIFO INVENTORY RESERVE PARTS BUCKET 32 SHOWING LESS THAN ZERO.MUST SHOW A CREDIT BALANCE.J33SS1CANNOT SEND A CREDIT BALANCE FOR PREPAID EXPENSES. BUCKET 33 SHOWING LESS THAN ZERO.MUST SHOW A DEBIT BALANCE.J35SS1CANNOT SEND A CREDIT BALANCE FOR LEASED VEHICLES NET. BUCKET 35 SHOWING LESS THAN ZERO.MUST SHOW A DEBIT BALANCE.J36SS1CANNOT SEND A CREDIT BALANCE FOR RENTAL VEHICLES NET. BUCKET 36 SHOWING LESS THAN ZERO.MUST SHOW A DEBIT BALANCE.J37SS1CANNOT SEND A CREDIT BALANCE FOR LAND AND IMPROVEMENTS NET. BUCKET 37 SHOWING LESS THAN ZERO.W WARNING CHECK TO MAKE SURE CORRECT, WILL NOT KEEP DEALER FROM SUBMITTINGSS SHOW STOPPER CANNOT SUBMIT WITHOUT CORRECTION
PAGE 1 EDIT ERROR EXPLANATIONSMUST SHOW A DEBIT BALANCE.J38SS1CANNOT SEND A CREDIT BALANCE FOR BUILDING COST. BUCKET 38 SHOWING LESS THAN ZERO.MUST SHOW A DEBIT BALANCE.J39SS1CANNOT SEND A DEBIT BALANCE FOR BUILDING DEPRECIATION. BUCKET 39 SHOWING LESS THAN ZERO.MUST SHOW A CREDIT BALANCE.J40SS1CANNOT SEND A CREDIT BALANCE FOR EQUIPMENT COST. BUCKET 40 SHOWING LESS THAN ZERO.MUST SHOW A DEBIT BALANCE.J41SS1CANNOT SEND A DEBIT BALANCE FOR EQUIPMENT DEPRECIATION. BUCKET 41 SHOWING LESS THAN ZERO.MUST SHOW A CREDIT BALANCE.J42SS1CANNOT SEND A CREDIT BALANCE FOR LEASEHOLDS COST. BUCKET 42 SHOWING LESS THAN ZERO.MUST SHOW A DEBIT BALANCE.J43SS1CANNOT SEND A DEBIT BALANCE FOR LEASEHOLDS AMORTIZED. BUCKET 43 SHOWING LESS THAN ZERO.MUST SHOW A CREDIT BALANCE.J44SS1CANNOT SEND A CREDIT BALANCE FOR FINANCE RECEIVABLES DEFERRED NET. BUCKET 44 SHOWING LESS THAN ZERO.MUST SHOW A DEBIT BALANCE.J45SS1CANNOT SEND A CREDIT BALANCE FOR RECEIVABLES - OFFICERS AND EMPLOYEES. BUCKET 45 SHOWING LESS THAN ZERO.MUST SHOW A DEBIT BALANCE.J46SS1CANNOT SEND A CREDIT BALANCE FOR CASH VALUE - LIFE INSURANCE. BUCKET 46 SHOWING LESS THAN ZERO.MUST SHOW A DEBIT BALANCE.J47SS1CANNOT SEND A CREDIT BALANCE FOR OTHER ASSETS - NET. BUCKET 47 SHOWING LESS THAN ZERO.MUST SHOW A DEBIT BALANCE.J51SS1CANNOT SEND A DEBIT BALANCE FOR NOTES PAYABLE NEW VEHICLES & DEMOS. BUCKET 201 SHOWING LESS THAN ZERO.MUST SHOW A CREDIT BALANCE.J52SS1CANNOT SEND A DEBIT BALANCE FOR NOTES PAYABLE USED VEHICLES NON CPO. BUCKET 202 SHOWING LESS THAN ZERO.MUST SHOW A CREDIT BALANCE.J57SS1CANNOT SEND A DEBIT BALANCE FOR NOTES PAYABLE CPO VEHICLES FRAN ONLY. BUCKET 401 SHOWING LESS THAN ZERO.MUST SHOW A CREDIT BALANCE.J53SS1CANNOT SEND A DEBIT BALANCE FOR NOTES PAYABLE REMARKETED VEHICLES. BUCKET 203 SHOWING LESS THAN ZERO.MUST SHOW A CREDIT BALANCE.J54SS1CANNOT SEND A DEBIT BALANCE FOR NOTES PAYABLE RECREATION VEHICLES. BUCKET 204 SHOWING LESS THAN ZERO.MUST SHOW A CREDIT BALANCE.J55SS1CANNOT SEND A DEBIT BALANCE FOR NOTES PAYABLE OTHER - SHORT TERM. BUCKET 205 SHOWING LESS THAN ZERO.MUST SHOW A CREDIT BALANCE.J56SS1CANNOT SEND A DEBIT BALANCE FOR NOTES PAYABLE LONG TERM - CURRENT PORTION. BUCKET 206 SHOWING LESS THAN ZERMUST SHOW A CREDIT BALANCE.J59SS1CANNOT SEND A DEBIT BALANCE FOR OVERDRAFT/LINES OF CREDIT (LINE OF CREDIT LIMIT). BUCKET 209 SHOWING LESS THAN ZMUST SHOW A CREDIT BALANCE.J60SS1CANNOT SEND A DEBIT BALANCE FOR ACCOUNTS PAYABLE. BUCKET 210 SHOWING LESS THAN ZERO.MUST SHOW A CREDIT BALANCE.J97SS1CANNOT SEND A DEBIT BALANCE FOR ACCOUNTS PAYABLE - CUSTOMER SALES TAX. BUCKET 403 SHOWING LESS THAN ZERO.MUST SHOW A CREDIT BALANCE.J61SS1CANNOT SEND A DEBIT BALANCE FOR INCOME TAXES. BUCKET 211 SHOWING LESS THAN ZERO.MUST SHOW A CREDIT BALANCE.J62SS1CANNOT SEND A DEBIT BALANCE FOR CUSTOMER DEPOSITS. BUCKET 212 SHOWING LESS THAN ZERO.MUST SHOW A CREDIT BALANCE.J63SS1CANNOT SEND A DEBIT BALANCE FOR CUSTOMER ACCOM./CONTRACTS/REP REFUNDS. BUCKET 213 SHOWING LESS THAN ZERO.MUST SHOW A CREDIT BALANCE.J64SS1CANNOT SEND A DEBIT BALANCE FOR ACCRUED TAXES. BUCKET 214 SHOWING LESS THAN ZERO.MUST SHOW A CREDIT BALANCE.W WARNING CHECK TO MAKE SURE CORRECT, WILL NOT KEEP DEALER FROM SUBMITTINGSS SHOW STOPPER CANNOT SUBMIT WITHOUT CORRECTION
PAGE 1 EDIT ERROR EXPLANATIONSJ65SS1CANNOT SEND A DEBIT BALANCE FOR ACCRUED PAYROLL & BONUSES. BUCKET 215 SHOWING LESS THAN ZERO.MUST SHOW A CREDIT BALANCE.J66SS1CANNOT SEND A DEBIT BALANCE FOR ACCRUED PROFIT SHARING (NON US). BUCKET 216 SHOWING LESS THAN ZERO.MUST SHOW A CREDIT BALANCE.J67SS2CANNOT SEND A DEBIT BALANCE FOR ACCRUED OTHER. BUCKET 217 SHOWING LESS THAN ZERO.MUST SHOW A CREDIT BALANCE.J68SS2CANNOT SEND A DEBIT BALANCE FOR ACCRUED DEFERRED INTEREST INCOME (NON US). BUCKET 218 SHOWING LESS THAN ZERMUST SHOW A CREDIT BALANCE.J75SS2CANNOT SEND A DEBIT BALANCE FOR MORTGAGES PAYABLE. BUCKET 225 SHOWING LESS THAN ZERO.MUST SHOW A CREDIT BALANCE.J76SS2CANNOT SEND A DEBIT BALANCE FOR NOTES PAYABLE - OFFICERS & OWNERS. BUCKET 226 SHOWING LESS THAN ZERO.MUST SHOW A CREDIT BALANCE.J77SS2CANNOT SEND A DEBIT BALANCE FOR NOTES PAYABLE - FORD. BUCKET 227 SHOWING LESS THAN ZERO.MUST SHOW A CREDIT BALANCE.J78SS2CANNOT SEND A DEBIT BALANCE FOR NOTES PAYABLE - OTHER. BUCKET 228 SHOWING LESS THAN ZERO.MUST SHOW A CREDIT BALANCE.J79SS3CANNOT SEND A DEBIT BALANCE FOR NOTES PAYABLE - LEASED VEHICLES. BUCKET 229 SHOWING LESS THAN ZERO.MUST SHOW A CREDIT BALANCE.J80SS4CANNOT SEND A DEBIT BALANCE FOR NOTES PAYABLE - RENTAL VEHICLES. BUCKET 230 SHOWING LESS THAN ZERO.MUST SHOW A CREDIT BALANCE.J81SS4CANNOT SEND A DEBIT BALANCE FOR ESTIMATED LIABILITY - REPO PURCHASE LOSS. BUCKET 231 SHOWING LESS THAN ZERO.MUST SHOW A CREDIT BALANCE.J82SS4CANNOT SEND A DEBIT BALANCE FOR OTHER LIABILITIES. BUCKET 232 SHOWING LESS THAN ZERO.MUST SHOW A CREDIT BALANCE.J84SS4CANNOT SEND A DEBIT BALANCE FOR CAPITAL STOCK. BUCKET 234 SHOWING LESS THAN ZERO.MUST SHOW A CREDIT BALANCE.J86SS4CANNOT SEND A DEBIT BALANCE FOR CAPITAL IN EXCESS OF STOCK PAR VALUE. BUCKET 236 SHOWING LESS THAN ZERO.MUST SHOW A CREDIT BALANCE.J88SS4CANNOT SEND A DEBIT BALANCE FOR FIXED ASSET REVALUATION (NON US). BUCKET 238 SHOWING LESS THAN ZERO.MUST SHOW A CREDIT BALANCE.J89SS4CANNOT SEND A CREDIT BALANCE FOR DIVIDENDS DECLARED. BUCKET 239 SHOWING LESS THAN ZERO.MUST SHOW A DEBIT BALANCE.J90SS4CANNOT SEND A DEBIT BALANCE FOR PARTNERS OR PROPRIETORS INVESTMENT. BUCKET 240 SHOWING LESS THAN ZERO.MUST SHOW A CREDIT BALANCE.J91SS4CANNOT SEND A CREDIT BALANCE FOR PARTNERS & PROPRIETORS DRAWING. BUCKET 241 SHOWING LESS THAN ZERO.MUST SHOW A DEBIT BALANCE.B42W1USED VEHICLE- NON CPO NOTES PAYABLE UNREASONABLE IN RELATION TO USED VEHICLE INVENTORYBUCKET 202 EXCEEDS 150% OF THE SUM OF BUCKETS 24 PLUS 25B44W1CPO VEHICLES (FRANCISE ONLY) NOTES PAYABLE UNREASONABLE IN RELATION TO USED VEHICLE INVENTORYBUCKET 401 EXCEEDS 150% OF THE SUM OF BUCKETS 301 PLUS 302B43W1USED REMARKETED NOTES PAYABLE UNREASONABLE IN RELATION TO USED VEHICLEREMARKETED INVENTORY.BUCKET 203 EXCEEDS 150% OF THE SUM OF BUCKETS 26 PLUS 27B49SS1Total Ford Parts Inventory bucket 0097 Plus Non Ford Parts Inventory bucket 0098 not equal to bucket 0028.B70SS1Notes Receivable Out of Balance Compared to Accounts Receivable Aging (Within /- 10) 506 520 513 527COMPARED TO BUCKET 6W WARNING CHECK TO MAKE SURE CORRECT, WILL NOT KEEP DEALER FROM SUBMITTINGSS SHOW STOPPER CANNOT SUBMIT WITHOUT CORRECTION
PAGE 1 EDIT ERROR EXPLANATIONSB71SS1Accounts Receivable Vehicle Out of Balance Compared to Accounts Receivable Aging (Within /- 10) 500 514 507 521COMPARED TO BUCKET 8B72SS1Accounts Receivable Parts, Service, & Body Out of Balance Compared to Accounts Receivable Aging (Within /- 10) 501 522 516 510 508 502 523 517 515 509 503 524COMPARED TO BUCKET 9B73SS1Ford Receivable W&P Claims Out of Balance Compared to Accounts Receivable Aging (Within /- 10) 504 518 511 525COMPARED TO BUCKET 11B74SS1Ford Incentives Out of Balance Compared to Accounts Receivable Aging (Within /- 10) 505 519 512 526COMPARED TO BUCKET 13B75SS1Notes Receivable Past Due Out of Balance Compared to Accounts Receivable Aging (Within /- 10) 513 527 520COMPARED TO BUCKET 50B76SS1Accounts Receivable Vehicle Past Due Out of Balance Compared to Accounts Receivable Aging (Within /- 10) 507 521 514COMPARED TO BUCKET 52B77SS1Accounts Receivable Parts, Service, & Body Past Due Out of Balance Compared to Accounts Receivable Aging (Within /- 10) 508 509 510 515 516 517 522 523 524COMPARED TO BUCKET 53W WARNING CHECK TO MAKE SURE CORRECT, WILL NOT KEEP DEALER FROM SUBMITTINGSS SHOW STOPPER CANNOT SUBMIT WITHOUT CORRECTION
Page 2 ChangesNO CHANGES
LINEOPERATINGDOLLARSSUMMARYMONTHUNITS YTDYTDCARTOTAL SALES23TOTAL DMYTOTAL SELLINGEXPENSEMTOTAL SELLING/MYADJUSTED SELLING GROSSYTOTAL FIXEDMEXPENSEY11 DEALER SALARYM12Y104613 OPERATING PROFIT14104715 LEASED VEHICLEMB45YADJUSTMENTSTOINCOME104816 RENTAL VEHICLE104917 RECREATIONAL VEHICLE18105119 OTHER INVENTORY INCOME105220 ADJ. TO INCOMEFORD MOTOR COMPANY21 PROGRAMS105322 INDEMNITIESNON US23DEALER24MONTHDEPARTMENT OPERATING SUMMARYTRUCK% TOTAL GROSS45SALES CODEOPERATING SUMMARYNO1P&A CODEDEALERBONUS() (105410551056EMPLOYEE105725 PROFIT BEFORE26 INCOME TAXTOTAL27 EST. INCOME TAXB17G81G28 )B46B47PNVSTOTAL1059106028 PROFIT SHARING NON US106129 COMBINED CAPITAL RESERVE30 NET PROFIT AFTER TAXADDITIONSMONTHCASH DISC. EARNED1309INTEREST INCOME1310DIVIDEND INCOME1311SALES FIXED ASSETS1312OTHER1313DOCUMENTATION FEES1314DEDUCTIONSCASH DISCOUNT1315OTHERTOTAL (Line 20)131631PNVS1317Lincoln Support1414Ford Support1415Ad StandardsCustomer Satisfaction Recognition (FoC)1062B30B30B17FORD MOTOR COMPANY PROGRAMS%TOTAL SALESG32B18YTD14191416G81B38B4832 TOTAL OVERHEAD EXPTOTAL (Line 21)33 TOTAL P, S, BS GROSSService Absorption: The Sum of Total Parts, Service & Body 'Shop34 NET OPERATING COSTGross Profits Divided By the Sum of Total Fixed Expense' Dealer Salary Parts,35VEHICLE GROSSService & Body Shop Sales ExpenseVAR. SALES EXP.(BENCHMARK IS 85% -- 100%)36TOTAL37MONTHYTD%%NON-US DEALER ADJUSTMENTS (MEMO)VARIABLE GROSS38 BREAK-EVEN UNITS N. O. C. / VAR. GROSS391423MONTHEXCHANGE RATE ADJUSTMENTMONETARY ADJUSTMENTYTD DOC FEES FOMOCO PROGRAMS PN/UVR(401443) (1444MONTH41Z85Z95 )YTD1445TOTAL PAYROLL42434445OPERATING46 TREND ANALYSISNEW UNITSCARTRUCKUSED UNITS RTLCARTRUCKTOTALCAR/TRKINCL WHSLSELLING/ADJUSTED*SELLING GROSS(000)NEW47 JANUARY48 FEBRUARY49 MARCH50 APRIL51 MAY52 JUNE53 JULY54 AUGUST55 SEPTEMBER56 OCTOBER57 NOVEMBER58 DECEMBER59 CURRENT YTD60 PRIOR YTDRED HI-LIGHTED AREAS WILL STOP STATEMENT FOR BEING SUBMITTEDUSEDPARTSSERVICEBODY SHOPFIXEDOPT PFTPFT BITNET PFTEXP (000)(000)(000)PNVS
Page 2 EDIT ERROR EXPLANATIONSG28SS2INDEMNITIES (NON US) BUCKET 1054 HAS INVALID VALUE. BUCKET 1054 NOT EQUAL 0 USA DEALERS CANNOT USEG32SS2PROFIT SHARING ( NON US) Bucket 1060 HAS INVALID VALUE BUCKET 1060 NOT EQUAL TO 0. USA DEALERS CANNOT USEG81SS2FORD MOTOR COMPANY SUPPORT SUM OF BUCKETS 1414, 1415, 1419, 1416ARE NOT EQUAL TO BUCKET 1053Z85SS2EXCHANGE RATE ADJUSTMENT (NON US) BUCKET 1443 HAS INVALID VALUE. BUCKET 1443NOT EQUAL 0 USA DEALERS CANNOT USEZ95SS2MONETARY ADJUSTMENT (NON US) BUCKET 1444 HAS INVALID VALUE. BUCKET 1444 NOT EQUAL 0USA DEALERS CANNOT USEB17SS2ADDITIONS TO INCOME OUT OF BALANCEBUCKET 1052 NOT EQUAL TO BUCKET 1317B18SS2ADDITIONS AND DEDUCTIONS TO INCOME OUT OF BALANCE BUCKETS 1309, 1310, 1311, 1312, 1313, 1314,MINUS 1315, 1316COMPARED TO BUCKET 1317B30SS2ADJUSTMENTS TO INCOME DEDUCTIONS BUCKETS 1315 OR 1316 ARE LESS THAN ZERO. CAN'T POST DEDUCTIONSTO INCOME AS AN ADDITION TO INCOME. REVIEW THE AMOUNT POSTED AND MOVE TO THE PROPER ACCOUNT.(THIS ACCOUNT IS A REDUCTION TO INCOME NOT AN ADDITION TO INCOME.)B45W2OPERATING PROFIT CARRY-FORWARD INACCURATE WITHIN 10BUCKET 1046 NOT EQUAL TO BUCKET 6055B46W2VALUE OF BONUSES QUESTIONABLE IN RELATION TO PROFITSBUCKET 1057 BLANK AND BUCKETS 1055 PLUS 1056 NOT EQUAL TO ZEROB47SS2NET PROFIT BEFORE INCOME TAX OUT OF BALANCE (WITHIN /- 10) 1046 1051- 1054 1047 1052- 1055 1048 1053- 1056 1049COMPARED TO BUCKET 1057B38SS2CUSTOMER SERVICE RECOGNITION (FoC) BUCKET 1416 HAS INVALID VALUE.BUCKET 1416 NOT EQUAL 0 USA DEALERS CANNOT USEB48SS2TOTAL FORD MOTOR COMPANY SUPPORT OUT OF BALANCE 1414 1419 1415 1416COMPARED TO BUCKET 1423W WARNING CHECK TO MAKE SURE CORRECT, WILL NOT KEEP DEALER FROM SUBMITTINGSS SHOW STOPPER CANNOT SUBMIT WITHOUT CORRECTION
Edit Changes Page 3New:C02WF3Bronco YTD units less than last month's YTD units. Verify unit counts Bucket 3154.D56WF3Bronco unit count questionable.Bucket 3154 has an unreasonable figure, units are greater than 3000Verify unit count.N66WF3Bronco gross questionable.Bucket 3157 divided by bucket 3154 per unit is less than ( 1500) or greater than 15,000Verify unit counts and gross dollars.X58SSF3Bronco sales Bucket 3156 without units Bucket 3154 or vice versa. Sales doll
ford of canada ford division : 2021: 2021 ford motor company dealer financial statement : 2021: p&a code: 0129: g14: dealer: rec'd. 0131 period of 0130: g10 address sales code: month ended 0132: city state zip code assets: balance sheet liabilities: 1 cash: on hand in bank x 0001: new vehicles & demos x:
2020 2022 FORD Explorer Yes No 2018 2019 FORD Explorer Yes 2019 2021 FORD Eco Sport Yes 2019 2019 FORD Fiesta Yes 2018 2019 FORD Flex Yes 2019 2019 FORD Focus Yes 2019 2020 FORD Fusion Yes 2021 2022 FORD F 150 Yes 2015 2020 FORD F 150 Yes FORD Mustang MACH-E Yes 2018 2021 FORD Super Duty Yes
pickup pickup pickup pickup pickup s10 s10 s10 s10 s10 s10 s10 s10 s10 s10 s10 s10 silverado silverado silverado silverado silverado silverado silverado silverado silverado silverado venture . 85 ford . 86 ford . 87 ford . 88 ford . 89 ford . 90 ford . 91 ford . 92 ford . 93 ford . 94 ford . 95 gmc 96 gmc 97 gmc 98 gmc 99 gmc 100 gmc
ford 4.6 - 16 valves - ford 4.6l/5.4l - sohc 24 valves 42 ford 4.6 - 32 valves 43 ford 351 c (2 barrel) - ford 351 n (sportsman head) 43 ford 351 w & gt40 head 43 ford 429 - 460 w/aftermarket heads 43 ford boss 302 - 351 c - 429 - 460 43 ford fe 352 -390 427 428 ford windsor 302 351 43 pontiac 400 -428 455 43 valves (5000 series hi performance) 44
Lake Powell Ford Page AZ 86040 Galpin Ford Prescott AZ 86305 Glenn Jones Ford Casa Grande AZ 85122 McSpadden Ford, Inc. Globe AZ 85501 Tate's Auto Center Holbrook AZ 86025 Horne Ford of Nogales, LLC Nogales AZ 85621 Freedom Ford Lincoln Thatcher AZ 85552 Oracle Ford Oracle AZ 85623 Lawley's Team Ford Sierra Vista AZ 85635 Show Low Ford Show Low .
Year Make Model EngineLiters EngineCID 1955 Mercury Custom 4.8 292 1955 Mercury Montclair 4.8 292 1955 Mercury Monterey 4.8 292 1957 Ford Courier Sedan Delivery 5.8 352 1957 Ford Custom 4.8 292 1957 Ford Custom 300 4.8 292 1957 Ford Del Rio Wagon 4.8 292 1957 Ford F Series 5.8 352 1957 Ford Ranchero 5.8 352 1958 Ford Club 5.8 352 1958 Ford Country Sedan 4.8 292 1958 Ford Country Sedan 5.4 332 .
eLLIott Ford LIncoLn Mercury Mount Pleasant, TX exceL Ford LIncoLn Mercury Carthage, TX Fenton Ford oF duMaS Dumas, TX FrankLIn Ford Wallisville, TX FrIendLy Ford Crosby, TX gene haMon Ford, Inc. Texas City, TX gene MeSSer Ford Lubbock, TX gILLeSPIe Ford San Antonio, TX gLenn PoLk Ford Gainesville, TX
FORD OF CANADA FORD DIVISION : 2022: AUDIT RULES ERROR & WARNING CODES: 2022 FORD MOTOR COMPANY DEALER FINANCIAL STATEMENT 2022: P&A CODE: 0129: G14: DEALER REC'D: 0131 . Ford Support B77 B76 J59 J13 G20 J11 J62 J63 J64 J16 ACCOUNTS RECEIVABLE. 0014 B23 B24 B58 J65 B41 B31 FROZEN CAPITAL (negative amount no frozen capital for dealership) N .
NEW 2013 FORD NEW 2013 FORD NEW 2013 FORD NEW 2013 FORD NEW 2013 FORD NEW 2013 FORD NEW 2013 FORD NEW 2013 FORD FOCUS FIESTA FUSION F-150 ESCAPE F-150 C-MAX EDGE 17,962 14,962 20,962 29,662 20,962 31,962 24,962 26,962 Stk #1300389 Stk #1300338 Stk #1300123 Stk #1300768 Stk #1300723 Stk #1300531 Stk #1300809 Stk #1300254 SiRiUS Radio .
