EN
Bookkeeping

How to Do Bookkeeping? Training on Daily, Weekly and Monthly Tasks, Document Organization, Control Formulas and Handing Over to Your Accountant

How do you do bookkeeping? Daily, weekly and monthly tasks, document filing, cash, account and inventory control formulas, and handover to the accountant: 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: What tasks does bookkeeping cover?
  3. Lesson 2: What setup is done when starting bookkeeping?
  4. Lesson 3: What tasks are done every day in bookkeeping?
  5. Lesson 4: What checks are done every week?
  6. Lesson 5: What tasks are done at month end?
  7. Lesson 6: How do you set up a document filing system?
  8. Lesson 7: Which formulas are used to check the records?
  9. Lesson 8: What is handed over to the accountant, and when?
  10. What are the most common mistakes in bookkeeping?
  11. How do you do bookkeeping with NetKasam?
  12. Mini quiz: Test what you have learned
  13. Conclusion: set up an end-of-day routine this week
  14. Frequently Asked Questions About How to Do Bookkeeping

A business owner new to bookkeeping usually puts it like this: "I issue the invoices, I put incoming invoices in a folder, and at month end I give them all to the accountant." When month end comes, the folder turns up missing receipts, bank transactions with no record of who paid how much, and products that show in inventory but are not on the shelf. The problem is not lack of knowledge but lack of routine: it is not clear which task is done on which day. So the answer to how do you do bookkeeping is not a definition but a schedule.

This article is not an explanation but an 8-lesson practical training. We will follow one month of a sample home textile seller with one shop and two marketplace stores, with figures: the routine to set up when starting, daily, weekly and monthly tasks, the document filing system, control formulas and the handover to the accountant. At the end there is a mini quiz with an answer key. For the definition and scope of bookkeeping, see the what is bookkeeping guide; here we cover how the work is done step by step.

What will you be able to do by the end of this training?

In short: You will set up a schedule that splits bookkeeping into daily, weekly and monthly tasks, record each document in the right place, check cash, account and inventory balances with formulas, and hand over a complete file to your accountant at month end.

Training mapThe six-step bookkeeping cycle
  1. 01
    SetupOpen customer and supplier, product, cash and bank accounts.
  2. 02
    Daily entriesEnter invoices, collections and payments on the same day.
  3. 03
    End of dayCount the cash, file the documents.
  4. 04
    Weekly checkReview receivables, payables and critical inventory.
  5. 05
    Month endDo the bank and account reconciliations.
  6. 06
    HandoverGive the documents and reports to the accountant.

The 8 lessons of the training: (1) scope of bookkeeping, (2) initial setup, (3) daily tasks, (4) weekly tasks, (5) monthly tasks, (6) document filing, (7) control formulas, (8) handover to the accountant.

Lesson 1: What tasks does bookkeeping cover?

In short: Bookkeeping is the daily recording of sales and purchase invoices, collections and payments, cash and bank movements, inventory receipts and issues, expenses and staff payments. Statutory books, tax returns and financial statements are the work of the certified public accountant (mali müşavir).

Knowing the line between the two is the first step to doing bookkeeping right. The business records its own transactions; the accountant prepares the statutory books and tax returns from these records. The more orderly the bookkeeping, the faster and more error-free the accountant's work.

TaskWho does it?Example
Issuing sales invoicesBusiness (bookkeeping)Invoicing shop and marketplace orders
Recording incoming invoicesBusiness (bookkeeping)Supplier, shipping, rent invoices
Processing collections and paymentsBusiness (bookkeeping)Wire transfers from customers, payments to suppliers
Cash and bank trackingBusiness (bookkeeping)End-of-day cash count, bank movements
Inventory trackingBusiness (bookkeeping)Goods receipts, sales issues, counts
Statutory books and tax returnsCertified public accountantVAT return, withholding tax return (muhtasar), financial statements

For details on the difference, see the glossary entry differences between bookkeeping and accounting.

Lesson 2: What setup is done when starting bookkeeping?

In short: On the first day, four lists are opened: customer and supplier accounts (customers and suppliers), products and opening inventory, cash and bank accounts with opening balances, and expense categories. Opening balances are fixed to a date, and every later entry is made after that date.

The example business starts bookkeeping on October 1. What is done on setup day:

  1. Customer and supplier accounts: 35 wholesale customers and 18 suppliers are opened with tax number, address and payment term details. No separate account is opened for individual shop and marketplace customers; sales are collected under a retail or marketplace account.
  2. Products: 420 products are entered with size and color variants, VAT rate and purchase cost. Opening inventory is taken from the September 30 count.
  3. Cash and bank: the shop cash register (opening ₺8,000) and two bank accounts (total ₺112,000) are opened; total cash at the start of the month is ₺120,000.
  4. Expense categories: rent, shipping, packaging, electricity-water-internet, advertising, staff, marketplace commission and other.

Opening figures must match your accountant's records dated September 30. Cash and bank openings are taken from the bank statement, account openings from the last reconciliation and the inventory opening from the count; estimates are not entered. If you are moving from existing software, see data migration when changing accounting software for transferring the lists.

Lesson 3: What tasks are done every day in bookkeeping?

In short: Four tasks are done every day: sales invoices are issued, incoming invoices and receipts are recorded, collections and payments are processed, and at the end of the day the cash is counted and documents are filed. An entry left past its day turns into a document you hunt for at month end.

FrequencyTaskTime (example)Control
Every daySales invoices, incoming invoices, collections and payments, end-of-day cash45 minutesCounted cash = recorded cash
Every weekReceivables and payables list, critical inventory, expense check1 hourOverdue receivables list
Every monthBank and account reconciliation, inventory check, month-end close, handover3 hoursBank balance = statement balance
Every yearYear-end count, carry-forward of opening balances1 dayCounted inventory = recorded inventory

The order of daily tasks matters:

  1. Sales invoices. Shop sales and marketplace orders are invoiced. The invoice must be issued within 7 days of delivery at the latest; for this rule and its exceptions, see within how many days must an invoice be issued.
  2. Incoming invoices and receipts. A supplier invoice is recorded together with the inventory receipt, and expenses such as shipping and rent under their own category. The original receipt and invoice, or the e-document, is kept.
  3. Collections and payments. Every wire transfer that lands in the bank is posted to the relevant account; a payment made to a supplier is also deducted from their account on the same day.
  4. End-of-day cash. The cash is counted and compared with the recorded amount; if there is a discrepancy, its cause is found the same day. Detailed method: daily cash count and cash register closing.

Lesson 4: What checks are done every week?

In short: Once a week, the receivables and payables list, critical inventory levels and expenses are checked. The aim is to catch errors in the daily entries before month end and to see a cash squeeze coming.

Receivables list. Open receivables are grouped by due date, and overdue customers are called. The example business's open receivables at the end of the week are ₺240,000:

Receivables agingBreakdown of ₺240,000 in open receivables by due date
  1. 0–30 days₺140,000
  2. 31–60 days₺60,000
  3. 61–90 days₺25,000
  4. Older than 90 days₺15,000

Prepared with sample values. The ₺15,000 older than 90 days is on the priority collection list.

58% of receivables (140,000 ÷ 240,000) are no more than 30 days old; the part that really needs attention is the ₺40,000 older than 61 days. Reminders are sent to these customers and, if necessary, new sales are tied to a risk limit. The full method is in how to track receivables.

Payables list. Supplier payments due over the next two weeks are compared with the bank balance. Critical inventory. Products that drop below the critical level are added to the order list. Expenses. The week's expenses are checked to see whether they were posted to the right categories and have documents; a shipping invoice entered in the wrong category throws off the cost analysis at month end.

Recommended readingHow to Track a Current Account?

Lesson 5: What tasks are done at month end?

In short: At month end, bank accounts are compared with statements, major accounts with reconciliation letters and, if needed, inventory with a count; missing invoices are completed, the month's cash position is drawn up and the records are handed over to the accountant.

The example business's cash movement in October goes from the start-of-month cash and bank total to the end-of-month total like this:

Monthly cashFrom ₺120,000 cash at the start of the month to ₺168,000 at the end
  1. Cash and bank at start of month₺120,000
  2. Customer and marketplace collections₺380,000
  3. Total cash₺500,000
  4. Supplier payments−₺210,000
  5. Expenses (rent, shipping, advertising, utility bills)−₺64,000
  6. Staff payments−₺58,000
  7. Cash and bank at end of month₺168,000

Prepared with sample values. Tax and Social Security Institution (SGK) payments are included in expenses according to the business's schedule.

The core of the month-end check is this: the ₺168,000 in the software must equal exactly the shop cash count plus the totals of the two bank statements. If it doesn't, there is an unrecorded collection, payment or bank charge. For the bank side see how to do a bank reconciliation, and for a step-by-step closing checklist see how to do the month-end close.

Other month-end tasks: reconciliation letters to the largest accounts, a check that no invoice is left unissued, a list of expenses whose invoices have not yet arrived and, if needed, a cycle inventory count (how to do an inventory count).

Lesson 6: How do you set up a document filing system?

In short: Each document type has a single place where it is recorded and a single place where it is stored. e-Invoice and e-Archive documents are kept in the system, and paper receipts and vouchers in a folder separated by month and type; the document number is written in the entry.

DocumentWhen is it recorded?Where is it recorded?
Sales invoice (e-Invoice, e-Archive)Same day as the saleSales invoices, the related account and inventory issue
Purchase invoiceSame day as the goods receiptPurchase invoices, supplier account and inventory receipt
Expense invoice and receiptDay of payment or when the document arrivesExpense category, cash or bank
Bank receiptDay the transaction appearsRelated account or expense
Collection receiptAt the time of cash collectionCash and customer account
Return invoiceDay the return is acceptedRelated account and inventory receipt

Marketplace sellers have an additional document: the commission and service invoices issued by the marketplace. These are recorded as expenses and matched with the marketplace's payout; details are in how to do marketplace accounting.

Recommended readingHow to Prepare a Cash Flow Statement?

Lesson 7: Which formulas are used to check the records?

In short: Four core balances are verified with formulas: cash, bank, accounts and inventory. The result of each formula is compared with a physical or external source (count, statement, reconciliation); if it doesn't match, there is a missing or wrong entry.

Control formulasFour balance checks in bookkeeping
  1. Cash balance = Carried forward + Cash collections − Cash payments (compared with the count)
  2. Bank balance = Carried forward + Incoming transfers − Outgoing payments − Bank charges (compared with the statement)
  3. Account balance = Previous balance + Invoices issued − Collections − Returns (compared with the reconciliation)
  4. Inventory = Carried forward + Purchases − Sales + Sales returns (compared with the count)

The formulas work with the same logic for every balance: opening, increases, decreases and comparison with an external source.

Example: A wholesale customer's balance at the start of the month is ₺18,000 owed. During the month, a ₺42,000 invoice was issued, ₺35,000 was collected and a ₺2,500 return was received. The expected balance is 18,000 + 42,000 − 35,000 − 2,500 = ₺22,500. If the customer says ₺20,000 in the reconciliation, the ₺2,500 difference is investigated; most of the time it is an invoice the other side has not yet processed, or a payment you have not processed.

How the example business's roughly 20 hours a month on this routine break down:

Time breakdownHow monthly bookkeeping time is split across tasks in the example business
  • Sales invoices5 hours25%
  • Incoming invoice and expense entry4 hours20%
  • Collections and payments4 hours20%
  • Cash and bank check3 hours15%
  • Inventory check2 hours10%
  • Month-end close and handover2 hours10%

Prepared with sample values; the time varies with the business's number of documents and the tools it uses.

Lesson 8: What is handed over to the accountant, and when?

In short: After the month ends, on the day agreed with the certified public accountant (mali müşavir), sales and purchase invoices, expense documents, bank statements, the cash report and, if needed, the inventory report are handed over. Since e-documents are in the system, often only paper documents and reports are sent.

  1. Fix the handover day. The tax return schedule may vary from business to business; agree with your accountant on which day documents will be handed over, and stick to the same day every month.
  2. Prepare a handover list. Sales and purchase invoice list, expense list, bank statements, cash report, account balance list, and return invoices issued during the month.
  3. Write down open issues. An expense whose invoice hasn't arrived, an unresolved reconciliation difference or a bank transaction missing its document is reported in a separate note.
  4. Give the accountant access. Instead of sending documents one by one, you can open a user account for your accountant in the software; that way they pull the reports themselves.

After the handover, no changes are made to entries for that month; if a correction is needed, it is made after informing the accountant. That way your records and the statutory books stay the same.

What are the most common mistakes in bookkeeping?

In short: The most common mistakes are saving documents up until month end, not comparing cash and bank, not posting collections to accounts, mixing personal spending with business expenses, and basing opening balances on estimates.

  1. Saving documents up until month end. This is where lost receipts and forgotten invoices come from; entries are made on the same day.
  2. Not comparing cash and bank. Until the balance in the software is compared with the count and the statement, you can't know it is correct.
  3. Not posting collections to accounts. If money entering the bank is recorded but not deducted from the account, the customer appears to owe money and a wrong reminder goes out.
  4. Mixing personal spending with business expenses. Business and personal accounts are kept separate.
  5. Entering opening balances as estimates. A first-day error carries over into every month's balance.
  6. Not reflecting returns in inventory and accounts. A return invoice is issued, the product goes back into inventory and the amount back to the account.
  7. Changing a month after it has been handed over. A difference arises between your records and the accountant's books.

How do you do bookkeeping with NetKasam?

In short: Bookkeeping is free in NetKasam: invoices, accounts, inventory, cash, bank, expenses and collections are kept in the same panel, and when an invoice is issued the account and inventory are updated together.

  • e-Invoice and e-Archive: The invoicing system is free; you only buy credits. You follow your invoices on the invoice tracking screen.
  • Customer and supplier accounts: With account tracking, you send online statements to your customers, send reconciliation letters in one click and define a risk limit per customer.
  • Inventory: Inventory management works by variant and warehouse; the inventory movements report and critical stock alert make the weekly check easier.
  • Expenses and cash-bank: Expenses are kept with their categories on the expense management screen, and cash and bank movements in the same panel.
  • Marketplace orders: Marketplace and e-commerce orders are gathered on a single screen and invoiced automatically (Connect and Global Plus plans).
  • Reports and the accountant: You can save the reports you pull regularly and export them to Excel; thanks to unlimited users, you can create a separate user for your accountant.

For all modules of the software and the plans, see the free bookkeeping software page.

Takeaways from the exampleOne month of bookkeeping, four key numbers
  • 20 hoursmonthly bookkeeping time in the example business
  • ₺168,000month-end cash matching the cash count and statements
  • 58%share of open receivables no more than 30 days old
  • ₺40,000receivables older than 61 days, to be collected first

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. If the start-of-month cash and bank total is ₺90,000, collections are ₺250,000 and payments and expenses total ₺270,000, what is month-end cash?
  2. An account's balance owed at the start of the month is ₺10,000; a ₺30,000 invoice was issued and ₺25,000 was collected. What is the expected balance?
  3. If open receivables are ₺200,000 and ₺120,000 of them are 0–30 days old, what is the percentage?
  4. On which day should an incoming shipping invoice be recorded?
  5. What do you do if an error is found in a month already handed over to the accountant?

Answer key:

  1. 90.000 + 250.000 − 270.000 = 70.000 ₺.
  2. 10,000 + 30,000 − 25,000 = ₺15,000 owed.
  3. 120.000 ÷ 200.000 × 100 = %60.
  4. On the day the document arrives, with its expense category.
  5. The entry is not changed on your own; it is corrected after informing the accountant.

Frequently Asked Questions About How to Do Bookkeeping

How do you do bookkeeping?

Sales and purchase invoices, collections and payments, cash, bank, inventory and expenses are recorded on the same day with their documents. Every week receivables, payables and inventory are checked, and every month bank and account reconciliations are done and the records are handed over to the accountant.

What do you need to start bookkeeping?

A customer and supplier account list, a product list with opening inventory, opening cash and bank balances, and expense categories. Opening figures are fixed to the same date as the accountant's records.

Can I do the bookkeeping myself?

Yes. Bookkeeping is the record of the business's own transactions; the business owner or an employee can do it. Statutory books and tax returns, however, are the responsibility of the certified public accountant (mali müşavir).

How much time a day does bookkeeping take?

It depends on the number of documents. In the example business, daily tasks take about 45 minutes, weekly checks 1 hour and month-end tasks 3 hours; about 20 hours a month in total.

Can bookkeeping be done in Excel?

It can be done, but because invoices, accounts, cash and inventory are kept on separate sheets, the same data is entered in more than one place and the risk of error increases. In bookkeeping software, an invoice updates the account and inventory together.

What do you do if there is a cash discrepancy in bookkeeping?

The discrepancy is investigated the same day: an unrecorded collection or payment, a wrong amount or a change error. A discrepancy whose cause cannot be found is recorded and reported to the accountant.

Which documents are handed over to the accountant?

Sales and purchase invoices, expense documents, bank statements, the cash report and the account balance list. Since e-documents are in the system, mostly paper documents and reports are sent.

Is bookkeeping paid in NetKasam?

No. Bookkeeping, including e-Invoice, e-Archive, customer and supplier accounts, inventory, cash, bank, expenses and collections, is always free; only e-Invoice credits and the marketplace or e-commerce integration plans are paid.

Conclusion: set up an end-of-day routine this week

The shortest way to get bookkeeping in order is a single habit: before closing every day, record that day's invoices, collections and payments and count the cash. Do this on the five days of this week; on Friday, look at the receivables list. When month end comes, you will have numbers to check, not documents to search for.

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 FreeFree Bookkeeping Software

Read similar articles

19 free tools

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

All tools