Paycheck Deduction Transaction Generator - Copy Columns Do Not Align with Transactions Sheet

I am having an issue with this Add-on. Not all of the columns in my Transaction Sheet are appearing in the Copy Columns section (AS:BG). The issue is specific to Amount, Tags and Note columns. I can only get 2 of these 3 columns to appear in Paycheck Deduction Transaction Generator sheet depending on their order in my transactions sheet. Any thoughts?

Which version are you using, Google Sheets or Excel? How many columns do you have in your Transactions sheet?

Google. I have these 16 columns (in order):

Date
Description
Category
Tags
Note
Amount
Account
Statement
Account #
Institution
Month
Week
Transaction ID
Check Number
Full Description
Date Added

I found I could insert a column at AW between Tags and Amount and drag the formula across row 3. Now I have all my columns and copy / paste aligns on my Transactions sheet.

:slight_smile:

Ahh, yea, adding a column can make things weird, and you did the correct step in fixing it. I’ll be updating the template soon with a different way of grabbing the column headers so that won’t be a problem anymore. Glad you got it fixed!