In order to enjoy all the features that our Excel applications provide, it is necessary to have macros enabled in Excel. You may receive a security warning that the file "contains macros by DJI Computer Solutions." In order for Checkbook for Excel to do its job, you will need to enable the macros it contains. Rest assured that the macros are safe and perform only basic Excel functions. They have been digitally signed and protected to insure that they were created by DJI Computer Solutions. To enable the macros and eliminate future warning for files published by DJI Computer Solutions, check the "Always trust macros from this publisher" check box and click the Enable Macros or OK button. If you are still having problems enabling macros or would like additional information, click this link to our Security page.
Checkbook for Excel functions more like a standalone program than a typical spreadsheet in that you do not enter data directly into the worksheets. The worksheets are all protected by design to prevent accidental changes that may keep the program from functioning properly. However, there is no need to unprotect any of the sheets as you can add, edit or delete categories and all the other program information using the functions on the Checkbook Tab located on the upper left portion of your Checkbook for Excel screen.
Anything can be added, deleted or edited using the correct program tool or function. Just search the help file index for what you want to do. For example, to enter a new transaction just click the appropriate tool in the Transactions section of the Checkbook Tab or click the New Transaction button of the Ledger Worksheet. To edit a transaction just double-click on the transaction. To add/edit/delete a category just click on the Categories tool on the Checkbook Tab to display the Categories dialog box. Then just click the New button and add the category you want. You can also edit or delete categories using this function.
This problem is occurs with a small number of users and is caused by poorly written Excel COM add-ins and has most often been associated with the Adobe Acrobat or Adobe PDF Maker add-in. Many programs install Microsoft Office add-ins without your knowledge It is recommended that you disable any Excel COM add-ins that are running. If that solves the problem, you can re-enable the disabled add-ins one at a time until you find the one causing the problem. A newer version of the add-in or program may be available that resolves the issue so check with the software company that created the add-in.
You can view the installed add-ins in Excel by clicking the Office orb or File Tab, then Excel Options, Add-ins, then select COM Add-ins in the Manage drop down list and click the Go button). (In Excel 97-2003 select Tools – Add-ins on the Excel Menu.) You can see which ones are active and de-activate them from this screen if you like. The problem seems to most evident in Excel 2010.
If you are not able to resolve the issue by disabling the offending add-in, we can specifically modify your Checkbook for Excel file to fix the problem. Just attach your Checkbook for Excel file to an e-mail and send it to firstname.lastname@example.org. We'll make the necessary modifications and e-mail your file back to you within 24 hours.
Checkbook for Excel can import Quicken Interchange Format (.QIF), Quicken Financial Exchange (.QFX), Open Financial Exchange (.OFX), Comma Separated Value and Comma Delimited (.CSV) files and other Excel Files directly using the “Import ” functions on the Checkbook Ribbon Tab. It can also import data from earlier versions of the program using the "Import Data from a Previous Version" import function. Just follow the directions in the Checkbook for Excel program help file for the file format you want to import.
Most banks use rather cryptic descriptions for the transactions listed in their download information. Importing this data directly into your ledger can make for a messy ledger. Checkbook for Excel allows you to view and edit each of our bank's downloaded transactions before you import it into the ledger. You can skip transactions that you already entered and edit the others so they make more sense.
If you would rather see them all, described below is a method for easily comparing the transactions in your actual ledger with those in the QIF file from your bank and identifying any transactions you might have missed.
- Create a new ledger in your Checkbook file called “Imported Data” or something similar that you’ll recognize.
- Import the data from your bank's QIF file into the newly created ledger.
- Use the Window – New command in Excel (View Tab - New Window in Excel 2007/2010/2013) to create a new Excel window with the new ledger showing. Make sure your actual bank ledger is showing in the original window.
- Use the Window – Arrange command (View Tab - Arrange All in Excel 2007/2010/2013) to arrange the two windows side by side or top and bottom, whichever you prefer.
- As you view each transaction in the imported data, check to see if it has already been entered in your bank ledger (or enter it in your bank ledger if necessary). Entering missing transactions can be almost completely automated by creating Recurring Transactions for your most common transactions and then you can enter them with just a few keystrokes. If you’re not familiar with Recurring Transactions, see the program help file for details.
- As you confirm or enter transactions in the bank ledger, you can use the check mark button at the top of the cleared column to check them off in the Imported Data ledger. You can also check them off in the bank ledger if you like since you’ll know the transaction has cleared if it is showing up in your download.
- Once you’re done, close the second window and delete the “Imported Data” ledger to clear all the data and to prevent it from being used accidentally. Just be careful not to delete the wrong ledger as there is no way to restore it except from a backup file.
This problem occurs when you set the Checkbook for Excel workbook as a "Shared Workbook" using the "Tools - Shared Workbook" function in Excel 97-2003 or the "Review" tab and "Share Workbook" tool in Excel 2007/2010/2013. To resolve the issue simply uncheck the "Share Workbook" checkbox using the aforementioned function.
This message occurs when the program is auto-filling the Payment information while entering a transaction and the Recurring Transaction it is trying to fill with does not have a valid category. To correct the problem and eliminate the message, go to the Recurring Transactions sheet (Transaction Accounts sheet in earlier versions) and check each row in the list of Recurring Transactions to make sure the category listed is a valid category that is also listed in the Categories sheet. Edit any Recurring Transaction that does not have a valid category by double-clicking on it and then substitute a valid category.
Each time you save your Checkbook for Excel file it creates a backup of the previously saved version of the file called "Backup of [file name].xlk. This provides an automatic backup in case your Checkbook for Excel file becomes corrupted or compromised in some other way. However, since it is saving two copies of the file it extends the time it takes to save the file. Although we do not recommend it, you can prevent the backup file from being created as follows: From the Excel menu, select File - Save As. In the Save As dialog box, click the Tools button and select the General Options and clear the "Always create backup" checkbox and then save the file.
Checkbook for Excel automatically anticipates the next check number when a check transaction is entered. In order to maintain this functionality, it is important that you write your checks in ascending order. If you start writing checks from a different book that have lower numbers, the program has no way of knowing and will still anticipate the higher check numbers. To correct this problem, wait until all the higher numbered checks have been marked as cleared. (The checks will be marked as cleared when you balance your checkbook.) Then use the "Archive Checkbook" tool to start a new checkbook file without the higher numbers.
You can display the lettered column headings on the ledger by going to the View tab and checking the "Headings" checkbox in the Show section. Then you can use your mouse to drag the column heading borders for the desired column width. You can also select Format - Column Width from the Home tab and enter the desired column width value without displaying the column headings.
The registration code is case sensitive so make sure you enter it exactly as it appears using the capital letters. Also, if you have Excel set to manual calculation, your registration code will not work. Select Tools-Options from the Excel menu, go to the Calculation tab and set Calculation to automatic. You will then be able to successfully enter your registration code. You can then set Calculation back to manual if you desire.
We do not support these types of modifications to the program so you must make these changes at your own risk. Also, please make a copy of your program before making these modifications. That way if things do not go as planned, you can revert to a previous copy.
- Mark one or more checks to print and go ahead and print them. Use the "Preview Checks Before Printing" option or shut off your printer so that the checks do not actually print. This will insure that there is text on your Checks sheet.
- Once you have check information on at least the first check in the Check sheet, make the modifications to the fonts on the first check only, then go ahead and print checks again. This will copy the formatting to all three checks and maintain it in the future.