Skip to content


GL journal entry template – additional rows

tracy jo dance asked 6 years ago
The GL journal entry template only contains 10 rows and accountants rarely have journal entries that are limited to 10 debits and credits.� What is the easiest way to expand this template to accommodate a JE for 800 to 1000 rows of data?
Patrick Roth Staff answered 6 years ago
Well, you don’t have to pre-expand the lines, you can just enter them one by one and the VBA code will auto-expand the number of rows for you.
However if you need to see 1000 rows of data before you enter them there is a Number of Rows on the SmartConnect tab – just set that to what you want it to be and it’ll set it for you.

If you would like to submit an answer or comment, please sign in to the eOne portal.