How Do You Get Branch and Employee Reports? A Guide to Branch Comparison, Per-Employee Expenses, Saved Reports, Excel Sharing and Report Permissions
How do you run branch and employee reports? Branch comparison, expenses by employee, saved reports, sharing via Excel and report permissions: an 8-lesson guide with examples.
Contents 14 sections
- What will you be able to do by the end of this training?
- Lesson 1: Which questions should a report answer?
- Lesson 2: What types of reports are there, and what data feeds them?
- Lesson 3: How do you build a report with filters?
- Lesson 4: How do you compare branches with each other?
- Lesson 5: How do you read expenses by employee?
- Lesson 6: How do you set up saved reports and a weekly routine?
- Lesson 7: How do you export a report to Excel and share it with your accountant?
- Lesson 8: How do you tie report access to permissions?
- What are the most common mistakes in branch and employee reports?
- How does NetKasam make branch and employee reports easier?
- Mini quiz: Test what you have learned
- Conclusion: Save three reports this week
- Frequently Asked Questions About Branch and Employee Reports
You have three branches and at the end of the month you look at a single total: ₺1,200,000 in sales. The number looks good, but how much did each branch contribute to it, which branch's stock is running down, and who generated most of the expenses? The total answers none of these questions. Pulling separate reports by branch, warehouse and employee from the same records is the difference between saying "the total is good" and saying "I know what is happening where".
This article is not a lecture but an 8-lesson hands-on course. We will answer how to run branch and employee reports with figures, using a sample business with three branches: report types, building reports with filters, comparing branches, reading expenses by employee, setting up a weekly routine with saved reports, sharing with your accountant via Excel and report permissions. At the end there is a mini quiz with an answer key. For the content of a weekly management report, see the article how to prepare a weekly management report; here we focus on running reports and breakdowns themselves.
What will you be able to do by the end of this training?
In short: You will run reports by branch, warehouse and employee, compare branches, save the report, export it to Excel and share it with your accountant, and tie report access to permissions.
- 01QuestionWhat decision will you make?
- 02FilterSelect a date, branch or warehouse.
- 03BreakdownSplit by branch, warehouse or employee.
- 04InterpretCalculate share, duration and difference.
- 05SaveSave the report and open it weekly.
- 06ShareExport to Excel and set permissions.
The course's 8 lessons: (1) the link between reports and decisions, (2) report types, (3) building a report, (4) comparing branches, (5) expenses by employee, (6) saved reports, (7) Excel and sharing with your accountant, (8) report permissions.
Lesson 1: Which questions should a report answer?
In short: Run a report to answer a question, not just for the sake of it. If the question is clear, the filter and breakdown will be clear too.
| Question | Reports | Breakdown |
|---|---|---|
| Which branch is falling behind? | Sales report | Branch |
| Which branch's stock is running low? | Inventory report | Branch or warehouse |
| Where are expenses piling up? | Expense report | Employee |
| Who owes us how much? | Account report | Customer |
Bookkeeping reports turn your daily records (invoices, collections, expenses, inventory movements) into summaries you can make decisions with. In NetKasam, reports sit in the same place as the records; you do not need to move the data to another program and merge it. For the overall scope of the report screen, see the reports page. Sample business: a retail and wholesale seller with three branches (Headquarters, Kadıköy, Çankaya) and four employees entering expenses.
Lesson 2: What types of reports are there, and what data feeds them?
In short: The sales report comes from invoices and orders, the inventory report from product stock, the expense report from expense slips, and the account report from customer and supplier balances.
| Reports | Data source | What does its accuracy depend on? |
|---|---|---|
| Sales | Sales invoices and orders | Invoices being issued on time |
| Inventory | Product stock, by branch and warehouse | Regular stock receipts and counts |
| Expenses | Expense slips | Expenses being entered immediately, not later |
| Account | Customer and supplier balances | Collections and payments being processed |
| Custom report | Your own criteria | Criteria being clearly defined |
A report's figures are only as reliable as the records entered. Issuing a sales invoice late, entering an expense afterwards or skipping a stock receipt makes the report incomplete. In NetKasam, marketplace and e-commerce orders are invoiced automatically through integration, so the risk is lower for these sales; for store and manually entered records, the habit of daily recording is decisive. For expense recording, see the article how to do an expense analysis.
Lesson 3: How do you build a report with filters?
In short: On the report screen, you select filters such as date, branch or warehouse and build the report in seconds. Setting up the same filter the same way each time is a prerequisite for comparison.
| Step | To do | Note |
|---|---|---|
| 1 | Choose the report type | Ready-made template or custom report |
| 2 | Enter the date range | Same logic every period (start of month–end of month) |
| 3 | Select a branch or warehouse | A single branch or compare all of them |
| 4 | Add other filters | Employee, customer, etc. |
| 5 | Build and save the report | Then it opens with one click |
The most common mistake with date ranges is including the last day of the month one month and leaving it out the next. If the two reports you compare cover a different number of days, the difference comes from scope, not real performance. To avoid this, tie the period boundary to a written rule: from the first of the month to the last day, both boundaries included. You can start with ready-made templates and build custom reports with your own criteria as the need arises.
Lesson 4: How do you compare branches with each other?
In short: Put the sales and inventory reports by branch side by side, and calculate each branch's share of the total and how many months its stock will last.
- Headquarters₺54045%
- Kadıköy₺38031.7%
- Çankaya₺28023.3%
Prepared with sample values. Shares: Headquarters 45.0%, Kadıköy 31.7%, Çankaya 23.3%.
| Branch | Sales | Share | Stock (units) | Monthly sales (units) | Stock cover |
|---|---|---|---|---|---|
| Main | 540.000 ₺ | %45,0 | 4.200 | 2.700 | 1.56 months |
| Kadıköy | 380.000 ₺ | %31,7 | 2.100 | 1.900 | 1.11 months |
| Çankaya | 280.000 ₺ | %23,3 | 1.400 | 1.400 | 1.00 month |
| Total | 1.200.000 ₺ | %100 | 7.700 | 6.000 | 1.28 months |
- Headquarters1.56 months
- Kadıköy1.11 months
- Çankaya1.00 month
Prepared with sample values. Stock cover = Branch stock ÷ Monthly sales quantity.
- Branch share = Branch sales ÷ Total sales × 100
- Stock cover = Branch stock ÷ Monthly sales quantity
- Difference between branches = Highest branch − Lowest branch
- Expense share = Employee's expenses ÷ Total expenses × 100
Prepared with sample values.
Two separate tasks come out of the table. First: Çankaya's stock runs out in exactly one month (1.00 month), while Headquarters has 1.56 months of stock. Çankaya needs a stock transfer or an order. Second: Kadıköy's share is 31.7%, but its stock lasts only 1.11 months; so both branches are approaching the risk threshold. For transferring stock between branches, see the article how to transfer stock between warehouses; to measure branch profitability, see the article how to measure profitability by branch.
When comparing branches, do not use sales value as the only measure: a large branch naturally sells more. Reading share, stock cover and change over time together gives a fairer picture. A small branch whose stock runs out quickly creates a more urgent task than a large branch with plenty of stock.
Lesson 5: How do you read expenses by employee?
In short: Select the employee who incurred the expense on the expense slip, and filter by employee when reporting. This makes differences in expenses between staff visible.
Example: A total of ₺96,000 in expense slips was entered during the period; four employees (A, B, C, D) are selected on the slips.
- Total expenses₺96,000
- Employee A−₺38,000
- Employee B−₺30,000
- Employee C−₺18,000
- Employee D₺10,000
Prepared with sample values. Shares: A 39.6%, B 31.3%, C 18.8%, D 10.4%.
| Employee | Expenses | Share | Interpretation |
|---|---|---|---|
| A | 38.000 ₺ | %39,6 | Highest; does it fit their role? |
| B | 30.000 ₺ | %31,3 | Second highest |
| C | 18.000 ₺ | %18,8 | Medium |
| D | 10.000 ₺ | %10,4 | Lowest |
Employee A's expenses are about 40% of the total. This is not an accusation but a question: does A's role (for example purchasing, hospitality, transport) make this amount natural? If the job description explains the high spending, there is no problem; if it does not, the expense items are examined one by one. For tracking employee expenses, see the article how to track employee expenses.
Recommended readingHow to Track Employee Expenses?Lesson 6: How do you set up saved reports and a weekly routine?
In short: Save a report you use often along with its criteria, and open it with one click next time. A report run under the same conditions makes weekly and monthly comparisons reliable.
| Saved report | Frequency | Question |
|---|---|---|
| Sales by branch | Weekly | Which branch stood out, and which fell behind? |
| Inventory by branch | Weekly (more often in busy periods) | Which branch's stock is running low? |
| Expenses by employee | Before month-end | Where are expenses piling up? |
| Account balances | Weekly | How much is owed to us, and by whom? |
The benefit of saving a report goes beyond time to consistency: when you set filters by hand every week, one week you may accidentally pick a different date or branch. Because a saved report keeps the criteria fixed, the comparison is "apples to apples". Reading the sales report weekly, the inventory report more often when order volume rises, and the expense report before the month-end close is a good start.
If the report you need is not in the system, you can send it to the NetKasam team as a development request; the team reviews the request and adds those found suitable to the system. For a general framework on drawing decisions from report results, the article how to calculate profit margin gives the basics of reading profit and expense data together.
- 45.0%Headquarters' share of total sales
- 1.00 monthÇankaya's stock cover
- 39.6%Employee A's share of expenses
- ₺260,000difference between the highest and lowest branch
Lesson 7: How do you export a report to Excel and share it with your accountant?
In short: Export the report in Excel format or print it, and send the file to your accountant. Using the same criteria ensures both sides' figures come out the same.
| Step | To do | Note |
|---|---|---|
| 1 | Clarify the period boundary | First day to last day of the month, both included |
| 2 | Open the saved report | Same filters, same period |
| 3 | Export to Excel | Put the date and branch in the file name |
| 4 | Send it to your accountant | Email or a shared folder |
| 5 | Get differences in writing | Does the difference come from missing records or from the rule? |
If there is a difference in figures with your accountant, the cause is usually a difference in criteria: one of you included returns and the other did not; one looked at the figure including VAT and the other excluding VAT. Writing at the top of the file which criteria it was run with prevents most of this debate. For the order of the month-end close, see the article how to do a month-end close.
NetKasam is cloud-based; you can access reports from anywhere with an internet connection, including outside the office. This makes it possible for the branch manager or you to open and check a report on the go. When sharing, if the file contains personal or confidential information (salaries, a specific account balance), send it only to the people concerned.
Lesson 8: How do you tie report access to permissions?
In short: Not every employee should see every report. Restrict access to report pages per user; information such as revenue and profit should stay with management.
| Role | Should see | Should not see |
|---|---|---|
| Cashier | Sales screen | Revenue, profit and expense reports |
| Branch manager | Their own branch's sales and inventory | Other branches and overall profit |
| Accounting | Invoice, account and expense reports | Unnecessary personal data |
| Management | All reports | – |
In NetKasam, access depends on permissions: users can be restricted from reaching report pages; for example, a cashier sees only the sales screen, and information such as revenue and profit stays with management. For role-based setup, see the article how to set up user permissions and the user and employee management page. Setting up permissions correctly once provides both data security and peace of mind internally.
Recommended ReadingHow Do You Set Up User Permissions?What are the most common mistakes in branch and employee reports?
- Looking only at the total. You cannot see which branch or employee had an effect.
- Mistaking missing records for performance. An unissued invoice looks like low sales.
- Changing period boundaries. Two reports cover a different number of days.
- Comparing branches only by amount. The large branch always looks ahead.
- Reading employee expenses as an accusation. The job description explains most differences.
- Rebuilding the report every week. A saved report ensures consistency.
- Giving everyone report permissions. Revenue and profit information spreads unnecessarily.
How does NetKasam make branch and employee reports easier?
- Branch and warehouse reports. Sales and inventory are seen separately for each branch or warehouse, and branches are compared (reports, branch and warehouse management).
- Expenses by employee. The employee who incurred the expense is selected on the expense slip, and the difference is reported by filtering by employee (expense management).
- Saved reports. A report you use often is saved with its criteria and opens with one click.
- Excel and printing. Reports are exported in Excel format or printed.
- Permission-based access. Users' access to report pages is restricted.
- Cloud access. Reports can be reached from anywhere with an internet connection.
- Bookkeeping is free. Bookkeeping, including reports, is free; for scope, see the pricing page.
Mini quiz: Test what you have learned
In short: Answer the 5 questions below, then compare with the answer key. 4 or 5 correct shows you have completed the training.
- Total sales are ₺1,000,000 and one branch's sales are ₺250,000. What is the branch's share?
- A branch has 900 units of stock and monthly sales of 600 units. What is its stock cover?
- Total expenses are ₺60,000 and one employee's expenses are ₺21,000. What is the expense share?
- Why should the criteria be written on a report shared with your accountant?
- Why shouldn't a cashier see revenue and profit reports?
Answer key:
- 250.000 ÷ 1.000.000 × 100 = %25.
- 900 ÷ 600 = 1.5 months.
- 21.000 ÷ 60.000 × 100 = %35.
- Differences in criteria (returns, VAT, dates) lead to differences in figures; if the criteria are written down, debate decreases.
- Revenue and profit are management information; spreading them unnecessarily creates security and internal harmony problems.
Frequently Asked Questions About Branch and Employee Reports
Can I get separate reports by branch and warehouse?
Yes. You can report each branch or warehouse separately to see its inventory and sales separately and, if you wish, compare branches with one another.
Can I see staff expenses as a report?
On an expense slip you can select the employee who incurred the expense, and when reporting you can filter by employee to see expense differences between staff.
How long does it take to prepare reports?
Once you select the filters and criteria, reports are ready within a few seconds. You can save a report you use often and reopen it in one click.
How do I share my reports with my accountant?
You can export the report to Excel format or print it; you can send the file to your accountant by email.
Can everyone see the reports?
No. Access depends on permissions; you can restrict users from reaching report pages.
Are reports paid?
No. Bookkeeping is free and reports are part of it.
How is stock cover calculated?
By dividing the branch's or warehouse's stock quantity by monthly sales quantity; the result shows how many months the stock will last.
What should I do if the report I need is not in the system?
You can send it to the NetKasam team as a development request; the team reviews the request and adds those found suitable to the system.
Conclusion: Save three reports this week
This week, save these three reports with their criteria: sales by branch, inventory by branch and expenses by employee. Keep the period boundary (start of month–end of month) in writing for each. In the coming weeks, when you open the same reports with one click and compare them, you will see which branch's stock is shrinking, which share is changing and where expenses are piling up much faster than by looking at the total. After running the first report, review report permissions too: revenue and profit should stay with management.
Bookkeeping Is Now Completely Free
Manage your bookkeeping and e-Invoice operations with NetKasam without paying a thing. Customer and supplier accounts, inventory, collections and more in one panel, completely free.