Ford Division Lincoln Division Ford Of Canada Ford Of Mexico 2022
DEALERSHIP FINANCIAL STATEMENTAUDIT RULESERROR & WARNING CODESFORFORD DIVISIONLINCOLN DIVISIONFORD OF CANADAFORD OF MEXICO2022EDITIONTHE INFORMATION CONTAINED WITHIN THIS GUIDE IS FOR USE BYDEALERSHIPS UTILIZING ELECTRONIC SUBMISSION SOFTWAREFOR FINANCIAL STATEMENT REPORTING(EFFECTIVE WITH JANUARY, 2022 DATA)BUSINESS MANAGEMENT DEPARTMENT
20220130PERIOD OFFINANCE CONTRACTSNEW4USED5MARKETABLE SECURITIES6NOTES RECEIVABLE7Discounted Notes Receivable (NON US)8VEHICLE9PARTS SERVICE BODY111213141516XXXXXMONEY MARKET/DEPOSITACCOUNTS B76B77BALANCE SHEET00010002B01G20 (B02 XB03B04INCOME TAX REFUNDFO W&P CLAIMSR VEHICLE HOLDBACKDINCENTIVESXFordR LincolnB2700630064 B28CSR (FoC)SupportSupportEJOBBERINCENTIVES/ESP/FLOORPLAN ASSISTANCE/OTHERC0065B290080NSUVE21 W anchiseOnly)SUV/TRUCKS29 PARTS 2B13B1500950096NON FOMOCO(30 ALLOWANCE - PARTS INVENTORY ADJUSTMENT009931 OTHER INVENTORIES32 LIFO INVENTORY33NEWRESERVE(MEMO: WORK IN PROCESS'0100USED(('0101PARTS34 PREPAID EXPENSESLEASED VEHICLES NETUNITS:CAR '0102SUV/TRUCK '010337 RENTAL VEHICLES 8J08OVERDRAFT/LINES OF CREDIT (LINE OF CREDIT LIMIT)0009J09ACCOUNTS PAYABLE0010J10ACCOUNTS PAYABLE - CUSTOMER SALES TAX0015J16INCOME TAXES0011J110012J12J13AMORTIZED46 RECEIVABLES - OFFICER & EMPLOYEES47 CASH VALUE - LIFE INSURANCE48 OTHER ASSETS - NETFROZEN CAPITALLONG TERM - CURRENT PORTIONCUSTOMER53for dealership)OPERATING ANALYSISJ170019J19ACCOMMODATIONS-SVC CONTRACTS/REP REFUNDACCRUEDPROFIT SHARING (NON US)OTHERDEFERRED INTEREST INCOME (CURR PORTION - NON US)0313J18 B91 NEWJ22 B21NET CASH0023J23 B22AVERAGE MONTH TOTAL EXPENSES0024J24 B23NET CASH OVER (UNDER)0025J25 B240301J14 B580302J15 B590026J26 B250027J27 B260028J28 HERLEASED VEHICLESRENTAL VEHICLESESTIMATED LIABILITY-REPOSSESSION PURCHASE 15J650216J66 G230217J670218J68 31J810232J820233TOTAL LIABILITIESB37NETWORTHCAPITAL IN EXCESS OF STOCK PAR 3J430044J44TOTAL LIABILITIES & NET WORTH0045J45RETURN ON INVESTMENT - ROI0046J46WORKING CAPITAL0047J47B34 B41ACTUALJ84J860237FIXED ASSET REVALUATION (NON US)SUB S023402360235RETAINED EARNINGSTREASURY STOCK(DIVIDENDS DECLARED)PARTNERS' ORINVESTMENTPROPRIETOR'SDRAWING)NET INVESTMENT(0238J88 G270239J890240J900241J9102420245B40 B41RECOMMENDED MINIMUM OR GUIDEACTUAL OVER(UNDER)ACCOUNTS RECEIVABLE AGINGMONTHYTD% TOTAL SALESVEH ACCTSPARTS ACCTSSERVICE ACCTEXPENSEBODY ACCTS57 OPERATING PROFITWARR RECV58 ADD/DED TO INCOME - BONUSESFORD INCENT59NOTES RECPROFIT BEFORE INCOME TAXSTOP STATEMENT FROM BEING SUBMITTED)B390244NET WORTHCURRENTYTD)0243NET PROFIT - AFTER INCOME TAX - YTDGROSSRED HILIGHTED AREAS WILLJ550206NETCASHOFFICERS & OWNERSPSB RECEIVABLESSALESJ540205XCAPITAL STOCK)J53 B4302040221MORTGAGES PAYABLEB310035VEHICLE EQUITY USEDOTHER LIABILITIES))J57 B440219TOTAL CURRENT LIABILITIES0022)04010214TAXESJ20)J21 B20USED VEHICLE INVENTORYMONTHXXDEPOSITSJ51J52 B420203021151 (negative amount no frozen capital PARTS INVENTORY52X0208PAYROLL & BONUSES0017004849 TOTAL ASSETSOTHER - SHORT TERMJ38COST45 FINANCE RECEIVABLES DEFERRED NET500006RECREATION VEHICLESJ37COSTDEPRECIATION43J05CERTIFIED VEHICLES (FRANCHISE ONLY)0038COSTDEPRECIATION41000500210202REMARKETED VEHICLES003738 LAND AND IMPROVEMENTS NET39J04)0201USED VEHICLES - NON CERTIFIEDJ03003435 TOTAL CURRENT ASSETS36PNAOYTAEBSLE00040020XNEW VEHICLES & DEMOS001418 ALLOWANCE - DOUBTFUL RECEIVABLECARSLIABILITIESJ01J020003001317 FINANCE RECEIVABLE CURRENT190132CITY STATE ZIP CODEASSETS3SALES CODEADDRESSCASH ON HAND IN BANK20131REC'DDEALERMONTH ENDED12022FORD MOTOR COMPANY DEALER FINANCIAL STATEMENTG14G100129P&A CODE31-6061-9091 0512B74B700519B74B700526B74B700506051305200527
PAGE 1 AUDIT RULESG02W1DEALER 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-90SS1New SUV inventory dollars Bucket 313 and zero unit inventory Sum of Buckets 310, 311 and 312 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 certified 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 SUV/Truck - Non certified inventory dollars Bucket 25 and zero unit inventory Bucket 91 or Vice Versa. MUST show unit count ifdollar inventory amount shows or show dollar amount if units are shown. MUST Enter Used SUV/Truck unit countor dollars.B-11SS160 day used SUV/Truck unit inventory Bucket 92 exceeds total unit inventory Bucket 91. Used SUV/Truck unit total MUSTbe more than 60 day stock. Check to see that total unit inventory includes 60 day units (memo only).G - 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 AUDIT RULESB-16SS1Used car Certified (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 SUV/Truck Certified Vehicles (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 SUV/Truck 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 SUV/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 SUV/Truck unit countor dollars.B-15SS160 day used remarketed SUV/Truck unit inventory Bucket 96 exceeds total unit inventory Bucket 94. Usedremarketed SUV/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-91W1New SUV inventory dollars Bucket 313 divided by total units Sum of Buckets 310, 311 and 312 is less than 8,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 Certified 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 SUV/Truck - Non Certified 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 Certified (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 SUV/Truck Certified (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 SUV/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 2 9 17 3 10 19 4 15- 20 5 11 21 6 12 313-7 13 22B-34SS1TOTAL ASSETS OUT OF BALANCE (WITHIN /- 10) 34- 39 35 40 36- 41 37 42 38- 43 23 24 25 301 302 26 27 28- 29 30- 31- 32 33COMPARED TO BUCKET 34 44 45 46 47COMPARED TO BUCKET 48W WARNING CHECK TO MAKE SURE CORRECT, WILL NOT KEEP DEALER FROM SUBMITTINGSS SHOW STOPPER CANNOT SUBMIT WITHOUT CORRECTION
PAGE 1 AUDIT RULESB-35B-37B39B40SSSSSSSS1111TOTAL CURRENT LIABILITIES OUT OF BALANCE (WITHIN /- 10) 211 216 201 205 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) 240 234 237 236 238- 241 235- 239TOTAL LIABILITIES AND NET WORTH OUT OF BALANCE (WITHIN /- 10) 233 242 243COMPARED 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.J16SS1CANNOT 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.J18SS1CANNOT SEND A CREDIT BALANCE FOR INVENTORY - NEW SUV. BUCKET 313 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 AUDIT RULESJ22SS1CANNOT 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 CERTIFIED. BUCKET 24 SHOWING LESS THAN ZERO.MUST SHOW A DEBIT BALANCE.J25SS1CANNOT SEND A CREDIT BALANCE FOR INVENTORY - USED SUV/TRUCKS NON CERTIFIED. BUCKET 25 SHOWING LESS THAN ZEROMUST SHOW A DEBIT BALANCE.J14SS1CANNOT SEND A CREDIT BALANCE FOR INVENTORY - USED CARS CERTIFIED. BUCKET 301 SHOWING LESS THAN ZERO.MUST SHOW A DEBIT BALANCE.J15SS1CANNOT SEND A CREDIT BALANCE FOR INVENTORY - USED SUV/TRUCKS CERTIFIED. 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 SUV/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.MUST 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.W WARNING CHECK TO MAKE SURE CORRECT, WILL NOT KEEP DEALER FROM SUBMITTINGSS SHOW STOPPER CANNOT SUBMIT WITHOUT CORRECTION
PAGE 1 AUDIT RULESJ52SS1CANNOT SEND A DEBIT BALANCE FOR NOTES PAYABLE USED VEHICLES NON CERTIFIED. BUCKET 202 SHOWING LESS THAN ZEROMUST SHOW A CREDIT BALANCE.J57SS1CANNOT SEND A DEBIT BALANCE FOR NOTES PAYABLE CERTIFIED VEHICLES FRAN ONLY. BUCKET 401 SHOWING LESS THAN ZERMUST 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.J65SS1CANNOT 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.W WARNING CHECK TO MAKE SURE CORRECT, WILL NOT KEEP DEALER FROM SUBMITTINGSS SHOW STOPPER CANNOT SUBMIT WITHOUT CORRECTION
PAGE 1 AUDIT RULESJ89SS4CANNOT 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 CERTIFIED NOTES PAYABLE UNREASONABLE IN RELATION TO USED VEHICLE INVENTORYBUCKET 202 EXCEEDS 150% OF THE SUM OF BUCKETS 24 PLUS 25B44W1CERTIFIED 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)B71SS1 506 520 513 527COMPARED TO BUCKET 6Accounts 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
LINEDEALEROPERATINGDOLLARSSUMMARYMONTHUNITS YTDCARYTDUTOTAL GROSSNU% TOTAL GROSSMONTH45YTDTOTAL TAL SELLING/M8ADJUSTED SELLING GROSSY9TOTAL FIXEDM10 EXPENSEY11 DEALER SALARYM12Y104613 OPERATING PROFIT14104715 LEASED VEHICLEMB45YADJUSTMENTSTOINCOME104816 RENTAL VEHICLE104917 RECREATIONAL VEHICLE18105119 OTHER INVENTORY INCOME105220 ADJ. TO INCOMEFORD MOTOR COMPANY105321 PROGRAMS22 INDEMNITIESNON US23DEALER24MONTHDEPARTMENT OPERATING SUMMARYSUV TRUCKNNTOTAL SALES23SALES CODEOPERATING SUMMARYNO1P&A CODEBONUS() (105410551056EMPLOYEE105725 PROFIT BEFORE26 INCOME TAXTOTAL27 EST. INCOME TAXB17G81G28B46)B47PNVSTOTAL CAR/TRKADDITIONSCASH DISC. EARNEDINTEREST INCOMEDIVIDEND INCOMESALES FIXED ASSETSOTHERDOCUMENTATION FEESDEDUCTIONSCASH DISCOUNTOTHERTOTAL (Line 16B18131732 TOTAL OVERHEAD EXPFORD MOTOR COMPANY PROGRAMSLincoln SupportFord SupportAd StandardsCustomer Satisfaction Recognition (FoC)TOTAL (Line 21)G8133 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%)VARIABLE GROSSNON-US DEALER ADJUSTMENTS (MEMO)EXCHANGE RATE ADJUSTMENTMONETARY ADJUSTMENT() (1059106129 COMBINED CAPITAL RESERVE30 NET PROFIT AFTER TAX%TOTAL SALESG32106028 PROFIT SHARING NON US10623136PNVSTOTAL3738 BREAK-EVEN UNITS N. O. C. / VAR. GROSS39MONTHYTD DOC FEES FOMOCO PROGRAMS 41B38B48%Z85Z95 )YTD1445TOTAL PAYROLL42434445OPERATING46TREND ANALYSISNEW UNITSCARSUVTRUCKUSED UNITS LING/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 SUBMITTEDUSEDPARTSFIXEDSERVICE BODY SHOP EXP (000)OPT PFTPFT BITNET PFT(000)(000)PNVS
Page 2 Audit RulesG28SS2INDEMNITIES (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 FR
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 .
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
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 .
Get an inside look at the benefits of Lincoln ownership at the Lincoln.com website. Donnell Ford Lincoln of Salem 152 Continental Drive (800) 686-0031 Salem, OH 44460 Team Ford Lincoln 905 Brady Avenue (740) 283-4131 Steubenville, OH 43952 Shults Ford Lincoln, Inc. 10401 Perry Highway (724) 934-2388 Wexford, PA 15090
Get an inside look at the benefits of Lincoln ownership at the Lincoln.com website. Donnell Ford Lincoln of Salem 152 Continental Drive (800) 686-0031 Salem, OH 44460 Montrose Ford Lincoln 2480 West State Street (877) 366-6876 Alliance, OH 44601 Klaben Ford Lincoln of Warren, Inc. 3853 Youngstown Road (888) 545-0281 Warren, OH 44484
Lincoln Aviator 2002 2005 T107BFL X Lincoln Continental 2000 2002 T107B Lincoln LS 2000 2002 T107BFL T107BFL X Lincoln Mark LT 2006 2008 T301B Lincoln MKC / MKT / MKX / MKZ 2006 2018 ET204 X Lincoln MKS / MKX 2009 2016 T301B ET201 Lincoln Navigator 2003 2017 T109B ET203 Lincoln Town Car 2003 2011 T1
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
The threat profile for SECRET anticipates the need to defend against a higher level of capability than would be typical for the OFFICIAL level. This includes sophisticated, well resourced and determined threat actors, such as some highly capable serious organised crime groups and some state actors. Reasonable steps will be taken to protect information and services from compromise by these .
