Free Affiliate Marketing & eCommerce P&L Templates

[WP00]

The p&l sheet I had was for ecom. I modified it for AM and decided to share both. I also took inspiration from L1Ghts P&L (scripts).

Information about the AM P&L sheet:

• There are three versions of the sheet at the bottom. Each version is different in the amount of things it tracks so you can choose which you need based on whatever you're working on.
• Even though ROI is big in the aff world, I like to know my profit margin. I included the profit margin in the two more detailed versions.
• Put dates and column names on all sides to make it easier and quicker to analyze the stats.

The difference between the 'auto' and 'manual' table:

• For the overview tables, auto uses formulas to calculate all your stats for you.
• Manual only uses formulas on gross profit and revenue. You can manually input your operating expenses (OpEx) and Non-operating expenses throughout the month.
• You can break down monthly/yearly bills and enter the amount in the daily columns. If you don't want the hassle and do not distort your data, you can add expenses to the manual table for a more