Project

General

Profile

Actions

Support #483

open

Help for Accounting Module

Added by Carsten Stanusch about 1 year ago. Updated 10 days ago.

Status:
New
Priority:
Normal
Assignee:
Target version:
Start date:
12/06/2023
Due date:
% Done:

0%

Estimated time:

Description

Hello,
I'm currently trying to understand the accounting module, but I can't get any further, even on your demo platform I couldn't understand how to set up a purchase transaction via the automatic booking of the ledgers.

I have set the following:
Purchase:
Credit Ledger = Sundry Creditors
Debit Credit Ledger = Purchase Accounts
Payment Credit Ledger = Bank Accounts
Payment Debit Ledger = Sundry Creditors

And for inventory:
Credit Ledger: Purchase Accounts
Debit Ledger: Current Assets

Then I create a purchase invoice, accept the payment and make the goods receipt...
When I then call up the Profit&Loss or Balance Sheet report, everything is 0

If I then play a little with the accounts, or if I choose not to carry out the goods receipt or the payment of the invoice, figures appear - but no matter what I set, the balance sheet and/or Profit&Loss is never correct.

Furthermore, I have noticed that the taxes preset for the purchase of goods are correctly broken down in the purchasing account, but not in the accounting module, although I have set up an account for taxes...

Can you possibly provide better instructions here?
Thank you very much.

Translated with DeepL.com (free version)


Files

purchasing.jpg (280 KB) purchasing.jpg dhanalakshmi c, 12/11/2023 12:58 PM
inventory.jpg (245 KB) inventory.jpg dhanalakshmi c, 12/11/2023 12:59 PM
accounting.png (317 KB) accounting.png dhanalakshmi c, 12/11/2023 12:59 PM
balance-invoice.png (31.4 KB) balance-invoice.png Carsten Stanusch, 12/12/2023 11:23 PM
balance-payment.png (31.7 KB) balance-payment.png Carsten Stanusch, 12/12/2023 11:23 PM
balance-receipt.png (15.7 KB) balance-receipt.png Carsten Stanusch, 12/12/2023 11:23 PM
pl-payment.png (47.2 KB) pl-payment.png Carsten Stanusch, 12/12/2023 11:23 PM
pl-invoice.png (47.3 KB) pl-invoice.png Carsten Stanusch, 12/12/2023 11:23 PM
pl-receipt.png (42.3 KB) pl-receipt.png Carsten Stanusch, 12/12/2023 11:23 PM
receipt.png (38.4 KB) receipt.png Carsten Stanusch, 12/12/2023 11:23 PM
supplier-invoice.png (44.9 KB) supplier-invoice.png Carsten Stanusch, 12/12/2023 11:23 PM
supplier-payment.png (26.2 KB) supplier-payment.png Carsten Stanusch, 12/12/2023 11:23 PM
transaction.png (34.1 KB) transaction.png Carsten Stanusch, 12/12/2023 11:23 PM
setting-inventory.png (24 KB) setting-inventory.png Carsten Stanusch, 12/12/2023 11:34 PM
setting-purchase.png (44.8 KB) setting-purchase.png Carsten Stanusch, 12/12/2023 11:34 PM
transaction-list.png (34.1 KB) transaction-list.png Carsten Stanusch, 12/12/2023 11:41 PM
trans-invoice.png (28.3 KB) trans-invoice.png Carsten Stanusch, 12/12/2023 11:41 PM
trans-payment.png (26.2 KB) trans-payment.png Carsten Stanusch, 12/12/2023 11:41 PM
trans-receipt.png (23.1 KB) trans-receipt.png Carsten Stanusch, 12/12/2023 11:41 PM

Updated by dhanalakshmi c about 1 year ago

Carsten Stanusch wrote:

Hello,
I'm currently trying to understand the accounting module, but I can't get any further, even on your demo platform I couldn't understand how to set up a purchase transaction via the automatic booking of the ledgers.

I have set the following:
Purchase:
Credit Ledger = Sundry Creditors
Debit Credit Ledger = Purchase Accounts
Payment Credit Ledger = Bank Accounts
Payment Debit Ledger = Sundry Creditors

And for inventory:
Credit Ledger: Purchase Accounts
Debit Ledger: Current Assets

Then I create a purchase invoice, accept the payment and make the goods receipt...
When I then call up the Profit&Loss or Balance Sheet report, everything is 0

If I then play a little with the accounts, or if I choose not to carry out the goods receipt or the payment of the invoice, figures appear - but no matter what I set, the balance sheet and/or Profit&Loss is never correct.

Furthermore, I have noticed that the taxes preset for the purchase of goods are correctly broken down in the purchasing account, but not in the accounting module, although I have set up an account for taxes...

Can you possibly provide better instructions here?
Thank you very much.

Translated with DeepL.com (free version)

Hi,
Your ledgers seems OK. Have you checked this auto post to accounting in settings?


Are you seeing the accounting transactions getting created?

Then I think the Profit & Loss and Balance Sheet should look OK

Updated by Carsten Stanusch about 1 year ago

Hello,

The settings look exactly the same for me, the checkboxes for automatic booking are activated.
Here's an example:
  1. Creating an invoice
  2. Balance & Profit/Loss according to invoice
  3. Payment of the invoice
  4. Balance & Profit/Loss after payment
  5. Goods receipt
  6. Balance & Profit/Loss after receipt of goods is then 0

Hello,
The settings look exactly the same for me, the checkboxes for automatic booking are activated.
Here's an example:
1. Creating an invoice
2. Balance & Profit/Loss according to invoice
3. Payment of the invoice
4. Balance & Profit/Loss after payment
5. Goods receipt
6. Balance & Profit/Loss after receipt of goods is then 0

The end result is the same, even if goods are received first and payment is made afterwards

Updated by Carsten Stanusch about 1 year ago

This are my settings (The Ledgers named as Type choosen):

Actions #5

Updated by dhanalakshmi c 11 months ago

  • Target version changed from 4.7.1 to 4.8
Actions #6

Updated by dhanalakshmi c 10 days ago

  • Target version changed from 4.8 to 4.9
Actions

Also available in: Atom PDF