EN
Bookkeeping

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
  1. What will you be able to do by the end of this training?
  2. Lesson 1: Which questions should a report answer?
  3. Lesson 2: What types of reports are there, and what data feeds them?
  4. Lesson 3: How do you build a report with filters?
  5. Lesson 4: How do you compare branches with each other?
  6. Lesson 5: How do you read expenses by employee?
  7. Lesson 6: How do you set up saved reports and a weekly routine?
  8. Lesson 7: How do you export a report to Excel and share it with your accountant?
  9. Lesson 8: How do you tie report access to permissions?
  10. What are the most common mistakes in branch and employee reports?
  11. How does NetKasam make branch and employee reports easier?
  12. Mini quiz: Test what you have learned
  13. Conclusion: Save three reports this week
  14. 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.

Course mapSix steps of branch and employee reporting
  1. 01
    QuestionWhat decision will you make?
  2. 02
    FilterSelect a date, branch or warehouse.
  3. 03
    BreakdownSplit by branch, warehouse or employee.
  4. 04
    InterpretCalculate share, duration and difference.
  5. 05
    SaveSave the report and open it weekly.
  6. 06
    ShareExport 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.

QuestionReportsBreakdown
Which branch is falling behind?Sales reportBranch
Which branch's stock is running low?Inventory reportBranch or warehouse
Where are expenses piling up?Expense reportEmployee
Who owes us how much?Account reportCustomer

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.

ReportsData sourceWhat does its accuracy depend on?
SalesSales invoices and ordersInvoices being issued on time
InventoryProduct stock, by branch and warehouseRegular stock receipts and counts
ExpensesExpense slipsExpenses being entered immediately, not later
AccountCustomer and supplier balancesCollections and payments being processed
Custom reportYour own criteriaCriteria 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.

StepTo doNote
1Choose the report typeReady-made template or custom report
2Enter the date rangeSame logic every period (start of month–end of month)
3Select a branch or warehouseA single branch or compare all of them
4Add other filtersEmployee, customer, etc.
5Build and save the reportThen 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.

ChartBreakdown of ₺1,200,000 in sales by branch (thousand ₺)
  • 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%.

BranchSalesShareStock (units)Monthly sales (units)Stock cover
Main540.000 ₺%45,04.2002.7001.56 months
Kadıköy380.000 ₺%31,72.1001.9001.11 months
Çankaya280.000 ₺%23,31.4001.4001.00 month
Total1.200.000 ₺%1007.7006.0001.28 months
ChartStock cover: Çankaya's stock runs out the fastest
  1. Headquarters1.56 months
  2. Kadıköy1.11 months
  3. Çankaya1.00 month

Prepared with sample values. Stock cover = Branch stock ÷ Monthly sales quantity.

FormulaFour formulas for branch comparison
  1. Branch share = Branch sales ÷ Total sales × 100
  2. Stock cover = Branch stock ÷ Monthly sales quantity
  3. Difference between branches = Highest branch − Lowest branch
  4. 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.

ChartBreakdown of ₺96,000 in expenses by employee
  1. Total expenses₺96,000
  2. Employee A−₺38,000
  3. Employee B−₺30,000
  4. Employee C−₺18,000
  5. Employee D₺10,000

Prepared with sample values. Shares: A 39.6%, B 31.3%, C 18.8%, D 10.4%.

EmployeeExpensesShareInterpretation
A38.000 ₺%39,6Highest; does it fit their role?
B30.000 ₺%31,3Second highest
C18.000 ₺%18,8Medium
D10.000 ₺%10,4Lowest

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 reportFrequencyQuestion
Sales by branchWeeklyWhich branch stood out, and which fell behind?
Inventory by branchWeekly (more often in busy periods)Which branch's stock is running low?
Expenses by employeeBefore month-endWhere are expenses piling up?
Account balancesWeeklyHow 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.

Takeaways from the exampleFour numbers from the sample period
  • 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.

StepTo doNote
1Clarify the period boundaryFirst day to last day of the month, both included
2Open the saved reportSame filters, same period
3Export to ExcelPut the date and branch in the file name
4Send it to your accountantEmail or a shared folder
5Get differences in writingDoes 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.

RoleShould seeShould not see
CashierSales screenRevenue, profit and expense reports
Branch managerTheir own branch's sales and inventoryOther branches and overall profit
AccountingInvoice, account and expense reportsUnnecessary personal data
ManagementAll 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?

  1. Looking only at the total. You cannot see which branch or employee had an effect.
  2. Mistaking missing records for performance. An unissued invoice looks like low sales.
  3. Changing period boundaries. Two reports cover a different number of days.
  4. Comparing branches only by amount. The large branch always looks ahead.
  5. Reading employee expenses as an accusation. The job description explains most differences.
  6. Rebuilding the report every week. A saved report ensures consistency.
  7. 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.

  1. Total sales are ₺1,000,000 and one branch's sales are ₺250,000. What is the branch's share?
  2. A branch has 900 units of stock and monthly sales of 600 units. What is its stock cover?
  3. Total expenses are ₺60,000 and one employee's expenses are ₺21,000. What is the expense share?
  4. Why should the criteria be written on a report shared with your accountant?
  5. Why shouldn't a cashier see revenue and profit reports?

Answer key:

  1. 250.000 ÷ 1.000.000 × 100 = %25.
  2. 900 ÷ 600 = 1.5 months.
  3. 21.000 ÷ 60.000 × 100 = %35.
  4. Differences in criteria (returns, VAT, dates) lead to differences in figures; if the criteria are written down, debate decreases.
  5. 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.

Start FreeCustomer and Supplier Account Tracking

Read similar articles

19 free tools

Commission, shipping, VAT and profit calculations in your browser, no sign-up needed.

All tools