How To Make A Autofill Check Register In Excel

21st Century Bookkeeping Tutorials - Depository financial institution Accounts

Import your Check Register text files into Excel.

Preview your check register in a way that displays the checks you wish to submit to the banking concern for the "Positive Pay" service. You can use the options to isolate the checks you've written by financial period, transaction date or check number. Y'all tin also produce the check annals for each business relationship individually if you desire.
Export the result to a *.txt file. To do this, within the Check register Preview window, at the acme, you volition find a small-scale envelope push button in the preview toolbar. Click the Envelope push button, then select the option to produce a Text file. Make certain to save the file in a location that you can remember.
Import to Excel. To do this, Open up Excel to a new spreadsheet, and then click the "Data Menu" to access the import tools. Click the push button to import a file from Text as illustrated. A window will pop up asking you to specify the file to exist imported. Select the file that y'all just produced (The default filename for Check register exports is "bachkreg.txt")

After clicking the "Open up" button, an import wizard will open offering options for your import. Make sure that you select the "Fixed width" option, and then scroll downwards the preview of your data and select the offset row yous want in your Excel file. Now, click "Next".

In stride 2, click between the check number column and the account number as shown in the preview to indicate that you want to create a cavalcade for the account number. And so click next.

Disregard the last stride in the sorcerer and click "Cease".

Place the result as suggested by the wizard and click "OK":
Modify the spreadsheet. Inside the resulting Excel file, click into the cell that contains the account number of your checking account. You lot tin apace copy the account number into each prison cell in the column past grabbing the "automobile-fill" push which appears equally a dot at the lower right side of the selected jail cell as circled in the illustration beneath. You lot may also want to change the top line of each cavalcade to label the contents of the columns below the information. You may as well wish to remove empty or irrelevant pieces of data.
Save your file and present the effect to your depository financial institution. The file you present will look something like the illustration below afterward manipulation. You should then save the file as *.csv or every bit *.xls per the instructions of your banking concern. Contact your banking concern almost the process of presenting the file to them.