Drake destination
Drake 4562 import, starting from the PDF you were handed
The usual route is PDF to Excel to Drake's 4562 import template, and the usual result is what PDF-to-Excel export does to a depreciation schedule: dates mangled, negative numbers dropped, wrapped descriptions split across two rows, and prior depreciation or method landing one column over. Drake's import (KB 15982) reads a spreadsheet in a fixed column order and creates a 4562 screen per asset. What doesn't exist is anything that turns the prior preparer's printout into that spreadsheet and proves the totals still tie. Upload the PDF and get back the file in Drake's own column order, reconciled against the schedule before you import and easy to reconcile again after.
What Drake's import actually wants
The 4562 import is positional: 104 columns in a fixed order, with the header row optional because Drake reads from row 2 onward. Dates go in as MMDDYYYY text. It is the richest contract of any destination we support — separate Federal, State, AMT and Book blocks, §179 split into elected versus allowed, prior bonus with a safe-harbor variant, and a full disposition block for Form 4797. We fill the columns the source schedule actually printed and leave the rest blank, because a blank tells Drake the truth and an invented number doesn't.
Reconcile the totals before and after import
Before you can download anything, the cost, prior depreciation and current depreciation totals printed on the PDF have to equal the sum of the rows we extracted, per activity and in grand total. If they're off, we show you the difference and point at the rows most likely responsible — usually one line that wrapped across a page break. After the import, run Drake's depreciation schedule and tie it back to the same printed totals. A basis that's wrong on import is wrong for every year the client stays with you.
About the 'For' and multi-form codes
The For column tells Drake which schedule or form an asset belongs to, and it is a required field on the 4562 screen. The accepted values come from the Drake Tax Manual: on a 1040 they are A, C, E, F, 2106, 4835, AUTO, 8829, K1P and K1S; the entity packages add their main form, COGS, 8825 and RENT. We write our reading of each asset's printed activity heading into that column and leave it blank when the heading names nothing we can read, so check column A before you import rather than trusting a guess. The multi-form code is 1 to 999, and Drake assumes 1 when it is blank.
Questions
- Which return types are covered?
- 1040, 1120, 1120-S, 1065, 1041 and 990. Drake's templates are nearly identical across them; the activity codes differ, which is why we ask which return you're preparing.
- Do dispositions come across?
- Yes, where the source schedule prints them: date sold, sales price, expense of sale and depreciation allowed map into Drake's 4797 block.