Use data validation for Account (from Chart of Accounts). Use SUMIFS to extract totals per account from Journal.
Not natively, but you can add an Inventory sheet with SUMIF formulas. 📄 License Free for personal and commercial use. Do not resell or redistribute as your own. 📩 Need Help? If you want me to email you the actual .xlsx file , reply with your email address and I will send it (text only – no spam). Or copy the above tables into Excel and use the formulas as shown. free download accounting software in excel full version
Yes, if saved on OneDrive/SharePoint, but avoid simultaneous edits. Use data validation for Account (from Chart of Accounts)