How to edit general ledger with budget comparison template

Hi @Kd, 

Thank you for your response and the helpful screenshots. Based on your description, here’s how to link a new account (e.g., “Barnes”) from YTD so it automatically appears and updates in the Monthly Expenses Summary just like the pre‑made ones. 

This template (General Ledger with Budget Comparison) ties sheets together through formulas: 

• Monthly Expenses Summary sums each month’s transactions for each account (usually from an Itemized Expenses table), often using SUMIFS. 
• YTD Budget Summary then adds the monthly totals across Jan–Dec for each account (simple SUM across that row). 

Because of that linkage, any new account must exist on both sheets and use the same formulas/labels to work automatically. 
 

To add 'Barnes' the right way, please try the following steps: 

1/ Add the account to YTD 

• On YTD Budget Summary, insert a row and enter the G/L Code (if you use it), Account Title (“Barnes”), and budget values in the appropriate columns. 
• Make sure the new row is inside the Excel table (so structured formulas auto‑fill). 

2/ Add the same account to Monthly 

• Open Monthly Expenses Summary. 
• Insert a new table row for “Barnes” in the account list (use Home → Insert → Insert Table Rows Above if it’s a table). 
• Fill in G/L Code and Account Title to match what you used on YTD exactly (no extra spaces). 

3/ Copy the formulas across Jan–Dec 

• Take a working row (e.g., “Advertising”) and copy its entire set of monthly formulas into the new “Barnes” row. 
• If your sheet is a proper Excel Table, structured references will auto‑adjust to the “Barnes” row. 

Note: After pasting, click a few month cells in the “Barnes” row and confirm the formulas point to the Itemized Expenses table or source range. 

4/ Example formulas (choose the one that matches your data) 

If you have a Date column in Itemized Expenses: 

• =SUMIFS(Itemized_Expenses[Amount], 
• Itemized_Expenses[Account Title], [@Account Title], 
• Itemized_Expenses[Date], ">=" & DATE(2025,1,1), 
• Itemized_Expenses[Date], "<=" & EOMONTH(DATE(2025,1,1),0)) 
  (Adjust the year/month for each Jan-Dec column; [ @Account Title ] points to “Barnes” in the current row.) 

If you have a Month text column (e.g., “Jan”, “Feb”): 

• =SUMIFS(Itemized_Expenses[Amount], 
• Itemized_Expenses[Account Title], [@Account Title], 
• Itemized_Expenses[Month], "Jan") 
  (Change "Jan" to each month as you move across the row.) 

5/ YTD “Actual” for Barnes 

Make sure the YTD sheet’s Actual YTD cell for “Barnes” sums the Monthly row: 

• =SUM('Monthly Expenses Summary'!C10:N10) 
  (Replace C10:N10 with the exact Jan-Dec span of the “Barnes” row in Monthly.) 

6/ Quick verification 

• Enter a sample transaction in Itemized Expenses tagged with Account Title = Barnes (and a date/month in January, for example). 
• Check that Monthly → Barnes → January updates from 0.00 to your transaction total. 
• Confirm that YTD → Barnes → Actual now reflects the sum of Jan-Dec. 

Note: 

• “Barnes” must be spelled/ spaced identically in Itemized Expenses, Monthly, and YTD. 
• New rows must be inside the Excel table range (look for the table style and filter drop‑downs). 
• If you use G/L Codes, keep them consistent on all sheets; codes can be text, not just numbers. 
• If totals don’t refresh, press F9 or ensure Formulas → Calculation Options is set to Automatic. 

I hope this helps you edit the General Ledger using the Budget Comparison template. I'm happy to assist and truly hope the information provided has been helpful. Please feel free to reach out if you run into any difficulties.

Hi @Kd,  

I hope everything is going well on your end.  

I’m following up on the support thread we've been working through together. I wanted to check in and see if the information I shared in my previous answer helped resolve the issue you were experiencing.  

If you're still experiencing any issues or have further questions, please feel free to reach out at any time. I’m always happy to help if you need anything else.  

We want to ensure everything is functioning smoothly and that your experience remains seamless.  

Thank you again for your collaboration throughout the troubleshooting process. 

I look forward to hearing from you soon.  

Hi @Kd,   

I hope you're having a great day. 

It’s been a pleasure working with you on this thread. I understand you may have other priorities at the moment, and I completely respect that. 

If you're still experiencing any issues or have come across new challenges, feel free to let me know which steps you're currently stuck on. I’m here and happy to assist whenever it’s convenient for you. 

Thank you again for your time and collaboration.  

I look forward to hearing from you whenever you're ready.