Accounting Merchandising Special Journals
Track cash, purchase, and sales transactions with automated chart of accounts integration.
This template organizes your merchandising transactions across three specialized journals—cash, purchase, and sales—each linked to your chart of accounts. It automatically timestamps the latest entry in each journal and uses VLOOKUP to map transactions to account codes, eliminating manual posting errors and keeping your books audit-ready.
What's inside
- Separate journals for cash, purchases, and sales transactions
- Chart of accounts integration with account codes
- Automatic last-entry-date calculation using MAX function
- VLOOKUP account code mapping
- Transaction code and supplier/customer tracking
- Data validation structure for consistent entries
Download this template
.xlsx · 5 sheets · included with lifetime access
More in Accounting & Bookkeeping
Accounting & Bookkeeping12 Month Cash Flow Forecast
Project monthly cash inflows and outflows to manage liquidity and plan for operating expenses.
- 12-month rolling forecast with expected vs. actual columns
- Month-by-month cash inflow and outflow tracking
- Automatic SUM calculations for cash position
Accounting & Bookkeeping12 Month Cash Flow Forecast
Project monthly cash inflows and outflows to manage liquidity and financial planning.
- 12-month rolling projection with expected vs actual columns
- Monthly period comparison structure
- Automated SUM formulas for period totals
Accounting & Bookkeeping3 Year Cash Flow Statement
Track operating, investing, and financing cash flows across three years with pre-built formulas.
- Three statement formats (3-year, yearly, 12-month)
- Pre-built SUM formulas for automatic calculations
- Color-coded input areas for easy data entry
Accounting & Bookkeeping3 Year Income Statement
Track revenue, expenses, and net income across three years to analyze financial trends and performance.
- Pre-formatted rows for revenue and expense categories
- Automatic SUM formulas for totals and subtotals
- Three-year side-by-side comparison columns