Difference between revisions of "Monthly closing reconciliation/sv"
From Marathon Documentation
(Updating to match new version of source page) |
(Updating to match new version of source page) |
||
| Line 1: | Line 1: | ||
__FORCETOC__ |
__FORCETOC__ |
||
| + | = Monthly closing and reconciliations= |
||
| + | == Monthly closing == |
||
| − | == Månadsavslut och avstämningar == |
||
| + | === Bookkeeping === |
||
| + | * Update periodical allocations in Accounting | Backoffice | Periodical allocations, the Update periodical allocations tab. |
||
| + | * Print the Reconciliation periodical allocations in Accounting | Reports, General ledger tab and compare with the balance on the account for periodical allocations. Read further under Reconciliation Periodical allocations. |
||
| + | * Print VAT declaration under Accounting | Reports, General ledger tab. See separate chapter about VAT reconciliation. |
||
| + | ===Sales ledger=== |
||
| + | * Check balances on the Trade debtor's accounts and compare with balance report in Accounting | Reports, Sales ledger tab. Read more under Reconciliation Sales ledger. |
||
| + | * Print Payment reminders in Accounting | Client invoices, Reminders tab. Reminders for single invoices is easily made in the Queries tab. Search the invoice and press the Payment reminders button. |
||
| + | * Interest invoicing is made in Accounting | Client invoices, Interest invoices tab. |
||
| + | ===Purchase ledger=== |
||
| + | * Check balances on the Trade creditor’s accounts and compare with balance report in Accounting | Reports, Purchase ledger tab. Read more under Reconciliation Purchase ledger. |
||
| + | Project accounting |
||
| + | * Check that everybody has reported their hours Use the report Reconciliation time. |
||
| + | * Register project related costs, book supplier invoices and expense reports. |
||
| + | * Update hours and purchases in Projects | Backoffice | Transactions, Update WIP tab. Adjust and invoice. Close finished projects. |
||
| + | * Zero invoice in Projects | Invoicing, Zero invoicing tab (especially if you use balance sheet account for project purchases). |
||
| + | * Print out WIP list accounting period in Projects | Reports and compare un-deducted pre-invoice (read more in chapter Reconciliation Pre-invoice) and purchase price WIP for purchases with the WIP account for purchases (if it is in use, read more in Reconciliation WIP account purchases). |
||
| + | * Compare invoiced in the project accounting with the revenue accounts in the bookkeeping that are used in the invoicing. Read more in Reconciliation Invoiced. |
||
| + | * Print project reports in Projects | Reports |
||
| + | ==Reconciliation== |
||
| + | ===Periodical allocations=== |
||
| + | '''Reconciliation:''' |
||
| + | * Update periodical allocations in Accounting | Backoffice | Periodical allocations, tab Update periodical allocations. |
||
| + | * Reconcile the allocations in Accounting | Reports, General ledger tab. The report is called Reconciliation Periodical allocations. Make a selection of the future allocations that are booked to the last date in that period. |
||
| + | * Example: Period 010725-blank and Accounting date blank -300625. Tick in Print out updated. Compare the amount of the list with the account for automatic periodical allocations. You can see its balance in e.g. Accounting | Queries, Accounts tab or in Accounting | Reports, General ledger tab. |
||
| + | '''In case of discrepancy:''' |
||
| − | === Bokföring === |
||
| + | * Print the report Reconciliation periodical allocations without selection on period or accounting dates. Make sure that the option Print updated not is ticked. Then you see all allocations that wait for update; there might be unupdated allocations in previous periods to catch up. |
||
| + | * Check the account for periodical allocations in Accounting | Queries, Accounts tab, or in Accounting | Reports, General ledger tab, Account specification. Check in the column Type if there have been bookings without assignment code. |
||
| + | === VAT === |
||
| − | * Uppdatera periodiseringar under {{pth|Ekonomi|Uppdatera periodiseringar}}. |
||
| + | Marathon keeps track of VAT- liable revenue, VAT-exempt revenue and foreign export with subaccounts. |
||
| + | XXXX01 – VAT-liable domestic |
||
| − | * Stäm av periodiseringar i {{pth|Ekonomi|Rapporter/Avstämning periodiseringar}} mot saldo på periodiseringskontot. Se vidare under Avstämning periodiseringar. |
||
| + | XXXX02 – VAT-exempt domestic |
||
| − | * Momsdeklaration skrivs ut under {{pth|Ekonomi|Rapporter}}. Se separat avsnitt för Momsavstämning. |
||
| + | XXXX03 – outside the EU |
||
| − | * Balans- och resultaträkning skrivs ut i {{pth|Ekonomi|Rapporter}}. |
||
| + | XXXX04 – within the EU |
||
| − | '''Kundreskontra''' |
||
| + | It is important to keep to Marathon’s structure, to avoid discrepancies. The system is not capable of interpreting and placing bookings on accounts without subaccounts on the VAT declaration. |
||
| − | * Stäm av saldo på kundfordringskonton mot saldolista i {{pth|Ekonomi| Rapporter}},flik Kundreskontra.Se vidare under Avstämning kundreskontran. |
||
| + | The VAT declaration in Accounting | Reports, General ledger tab, requires that the VAT is booked away with a reconciliation account each month. It is recommended that the previous month’s VAT is booked away in the beginning of the following month. That way you can see the VAT history. |
||
| + | '''Reconciliation''' |
||
| − | * Påminnelser skrivs ut i {{pth|Ekonomi|Kundfakturor}} flik Påminnelser. Vid påminnelse på enstaka fakturor kan man istället göra påminnelsen under fliken Frågor genom att söka fram fakturan och göra påminnelser därifrån. |
||
| + | * Make a control count of the VAT declaration for the period. |
||
| + | '''In case of discrepancy:''' |
||
| + | * Make sure that the VAT for previous month is booked away. There might be new transactions after the declaration, which means that the VAT amount this month might be higher. |
||
| + | * Print out list VAT reconciliation in Accounting | Reports, General ledger tab and make a selection on Period. Here you can see all entries without “correct” Vat booked. |
||
| + | * Look through the VAT account in the Account specification to see that no manual rebookings have been made (except the VAT). The specification is in Accounting | Reports, General ledger tab. |
||
| + | ===Sales ledger=== |
||
| − | * Räntefakturering görs i {{pth|Ekonomi|Kundfakturor/Räntefakturor}} |
||
| + | Reconciliation |
||
| + | * Print out balance list per reconciliation date in Accounting | Reports, Sales ledger tab. Check the total amount and compare with the balance on the trade debtor’s account. |
||
| + | '''In case of discrepancy:''' |
||
| + | * Print out the list Reconciliation to GL in Accounting | Reports, Sales ledger tab to see what day the discrepancy occurred. |
||
| + | * Print the list again and select only on the day that the discrepancy occurred, untick the box “Only Summary”. |
||
| + | * Check the bookings in the account specification in Accounting | Reports, General ledger tab and check if there are any bookings that lack assignment code in the Type column. |
||
| + | * Finally check all invoices in the sales ledger and compare with the invoice amount in the bookkeeping. |
||
| + | ===Purchase ledger=== |
||
| − | '''Leverantörsreskontra''' |
||
| + | '''Reconciliation:''' |
||
| + | * Print out balance list in Accounting | Reports, Purchase ledger tab. Check the total amount and compare with the balance on the trade creditor’s account. |
||
| + | '''In case of discrepancy:''' |
||
| − | * Stäm av saldo på leverantörsskuldskonton mot saldolistan under {{pth|Ekonomi|Rapporter}},flik Leverantörsreskontra. Se vidare under Avstämning leverantörsreskontran. |
||
| + | * Print out the list Reconciliation to GL in Accounting | Reports, Purchase ledger tab to see what day the discrepancy occurred. |
||
| + | * Print the list again and select only on the day that the discrepancy occurred, untick the box “Only Summary”. |
||
| + | * Check the bookings in the account specification in Accounting | Reports, General ledger tab and check if there are any bookings that lack assignment code in the Type column. |
||
| + | * Finally check all invoices in the purchase ledger and compare with the invoice amount in the bookkeeping. |
||
| + | === Project accounting === |
||
| + | ==== Pre-invoice ==== |
||
| + | '''Reconciliation''' |
||
| + | * Print out WIP list Accounting period per reconciliation date in Projects | Reports. Enter all project types and tick the box Totals only. Compare WIP pre-invoiced with the account balance in the bookkeeping. Remember to summarize all subaccounts, i.e. 242001, 242002 etc. |
||
| + | '''In case of discrepancy:''' |
||
| + | * Check the bookings on the account for pre-invoice in the Account specification in Accounting | Reports, General ledger tab. There might be manual bookings during the period. |
||
| + | ====WIP account purchases==== |
||
| + | Purchases in Marathon can either be expensed directly when the invoice is registered or be posted on a WIP account and expensed when invoicing the client. To avoid discrepancy between the WIP account and the WIP in project accounting, no manual bookings should be registered on the WIP account, and no purchases should be registered directly in the project accounting. |
||
| + | '''Reconciliation:''' |
||
| + | * Make sure that all purchases are updated for the period in Projects | Backoffice | Transactions, Update WIP tab. |
||
| + | * Print WIP list accounting period in Projects | Reports per reconciliation date. Compare the total amount for purchases purchase price with the balance on the WIP account in Accounting | Queries, Accounts tab. Alternatively, print an account statement in Accounting | Reports, General ledger tab. |
||
| + | In case of discrepancy |
||
| + | * Check that all purchase codes have expenses accounts in Projects | Backoffice | Base registers. |
||
| + | * Check the vouchers on the WIP account in Accounting | Queries or in the account specification in Accounting | Reports, General ledger tab. There might be manual bookings made during the period. |
||
| + | * Check that Closing balance for the previous year agrees with current year’s Opening balance in the bookkeeping. |
||
| + | * If an invoice is reversed after being transferred ti WIP account, the expense must be re-posted manually. |
||
| + | ====Invoiced==== |
||
| + | * Print out Reconciliation PRO | MED for the period in Accounting | Reports, General ledger tab. If there is a discrepancy, open the row and check the invoiced with discrepancy. The reason for the discrepancy is almost always that an invoice has been manually corrected in Vouchers. |
||
| + | * You can also print the report Printout invoice list in Projects | Reports and compare with the revenue accounts in the bookkeeping that are used in the invoicing. You can see the accounts on the cost codes in Projects | Backoffice | Base registers. Remember to reconcile all revenue accounts with VAR account suffixes 01 (domestic VAT), 02 (domestic VAT-exempt), 03 (outside EU), and 04 (within EU). |
||
| + | '''In case of discrepancy''' |
||
| + | * Check possible manual bookings on the revenue accounts on all voucher types, except for client invoice. |
||
| − | '''Projektredovisning''' |
||
| + | [[Category:avs-avs-en]] [[Category:Manuals]] [[Category:Accounting]] |
||
| − | * Kontrollera att alla rapporterat sina timmar i {{pth|Projekt|Rapporter}},Avprickning tid. |
||
| − | |||
| − | * Registrera in projektrelaterade kostnader, bokför leverantörsfakturor och kvittoredovisningar. |
||
| − | |||
| − | * Uppdatera timmar och inköp i {{pth|Projekt|Registrering, korrigering och uppdatering}}. |
||
| − | |||
| − | * Justera och fakturera. Stäng avslutade projekt. |
||
| − | |||
| − | * Nollfakturera i {{pth|Projekt|Nollfakturering}} (extra viktigt om ni använder balanskonto för projektinköp). |
||
| − | |||
| − | * Skriv ut lagerlista bokföringsperiod under {{pth|Projekt|Rapporter}} och stäm av oavräknat aconto (se vidare under Avstämning aconto) och inprislagret för inköp mot lagerkontot för inköp (om det används, se vidare under Avstämning lagerkonto inköp). |
||
| − | |||
| − | * Stäm av fakturerat i projektredovisningen mot de intäktskonton i bokföringen som används vid faktureringen. Se vidare under Avstämning fakturerat. |
||
| − | |||
| − | * Projektrapporter skrivs ut under {{pth|Projekt|Rapporter}} |
||
| − | |||
| − | === Avstämning periodiseringar === |
||
| − | |||
| − | '''Avstämning:''' |
||
| − | |||
| − | * Uppdatera periodiseringar i {{pth|Ekonomi|Uppdatera periodiseringar}} |
||
| − | |||
| − | *Stäm av periodiseringarna i {{pth|Ekonomi|Rapporter}}/Avstämning periodiseringar genom att selektera på de periodiseringar som ligger framåt i tiden och som är bokförda fram till sista datumet i den aktuella perioden, exempelvis period 1906-9999 och bokföringsdatum 000000-190531. Kryssa i Skriv ut uppdaterade. Beloppet på listan stäms av med kontot för automatiska periodiseringar. Saldot på kontot kan man se i {{pth|Ekonomi|Frågor/Konton}} eller {{pth|Ekonomi|Rapporter/Kontospecifikation}} |
||
| − | |||
| − | '''Vid differens:''' |
||
| − | |||
| − | * Skriv ut rapport Avstämning periodiseringar utan att selektera på period eller bokföringsdatum. Valet Skriv ut uppdaterade ska vara urbockat. Du får då ut allt som ligger för uppdatering och på så vis fånga upp eventuella gamla periodiseringar som man har missat att uppdatera för gamla perioder. |
||
| − | |||
| − | * Kontrollera i {{pth|Ekonomi|Rapporter}}, Kontospecifikation för att se om några bokningar har gjorts utan integrationskod. |
||
| − | |||
| − | === Momsavstämning === |
||
| − | |||
| − | Marathon håller koll på momspliktig intäkt, momsfri intäkt och export utanför landet genom att använda underkonton: |
||
| − | |||
| − | |||
| − | XXXX01 – momspliktigt inom landet |
||
| − | |||
| − | XXXX02 – momsfritt inom landet |
||
| − | |||
| − | XXXX03 – utanför EU |
||
| − | |||
| − | XXXX04 – inom EU |
||
| − | |||
| − | För att undvika differens så bör den struktur som Marathon föreslår hållas. Systemet kan inte tolka och placera bokningar gjorda på konton utan underkonto rätt på momsdeklarationen. |
||
| − | |||
| − | Momsdeklarationen i {{pth|Ekonomi|Rapporter}}förutsätter att momsen bokas bort mot avstämningskonto varje månad. |
||
| − | För att kunna se momsen bakåt i tiden rekommenderas att föregående månads moms bokas bort i början av nästa månad. |
||
| − | |||
| − | === Avstämning === |
||
| − | |||
| − | * Kontrollräkna din momsdeklaration för den aktuella perioden. |
||
| − | |||
| − | ''' Vid differens:''' |
||
| − | |||
| − | * Kontrollera att förgående månads moms är bortbokad. Eventuellt kan transaktioner inkommit sedan redovisningen var gjord vilket medför att momsbeloppet denna månad blir högre. |
||
| − | |||
| − | <div class="mw-translate-fuzzy"> |
||
| − | * Ta ut listan Momsavstämning under Ekonomi/Rapporter och selektera på den period du vill stämma av. Här redovisar systemet de poster som inte har ”rätt” utgående moms uppbokad. |
||
| − | </div> |
||
| − | |||
| − | * Titta igenom momskontot i {{pth|Ekonomi|Rapporter}}, Kontospecifikation för vald period |
||
| − | |||
| − | så att inga manuella ombokningar är gjorda (förutom ombokningen av momsen). |
||
| − | |||
| − | === Avstämning kundreskontran === |
||
| − | |||
| − | '''Avstämning''' |
||
| − | |||
| − | * Ta ut saldolista {{pth|Ekonomi|Rapporter}} Kundreskontra per avstämningsdatum. Kontrollera det totala beloppet och jämför mot saldot på kundfordranskontot. |
||
| − | |||
| − | '''Vid differens:''' |
||
| − | |||
| − | * Skriv ut listan Avstämning mot BOK i {{pth|Ekonomi|Rapporter}}Kundreskontra för att se vilket datum differensen uppstod. |
||
| − | |||
| − | * Skriv ut listan igen och selektera endast per det datum differensen uppstod, och kryssa ur "Endast sammandrag". |
||
| − | |||
| − | *Kontrollera bokningarna i {{pth|Ekonomi|Rapporter}},Kontospecifikation för att se om några bokningar har gjorts utan integrationskod. Se kolumn Typ. |
||
| − | |||
| − | * Avsluta med att pricka av varje faktura i kundreskontran mot fakturabeloppet i bokföringen. |
||
| − | |||
| − | === Avstämning leverantörsreskontra === |
||
| − | |||
| − | '''Avstämning:''' |
||
| − | |||
| − | * Ta ut saldolista {{pth|Ekonomi|Rapporter}}, Leverantörsreskontra. Notera det totala beloppet och jämför med saldot på leverantörsskuldskontot. |
||
| − | |||
| − | '''Vid differens:''' |
||
| − | |||
| − | * Skriv ut Avstämning mot BOK i {{pth|Ekonomi|Rapporter}}, Leverantörsreskontra för att se vilket datum differensen uppkommit. |
||
| − | |||
| − | * Skriv ut listan igen och selektera endast per det datum differensen uppstod och kryssa ur "Endast sammandrag". |
||
| − | |||
| − | * Kontrollera bokningarna i {{pth|Ekonomi|Rapporter}},Kontospecifikation för att se att inga bokningar utan integration är gjorda. Se i kolumnen Typ |
||
| − | |||
| − | * Avsluta med att pricka varje faktura i leverantörsreskontran mot fakturabeloppet i bokföringen |
||
| − | |||
| − | === Avstämning projektredovisningen === |
||
| − | |||
| − | '''Avstämning aconto''' |
||
| − | |||
| − | '''Avstämning''' |
||
| − | |||
| − | *Ta ut lagerlista bokföringsperiod i {{pth|Projekt|Rapporter}} per avstämningsdatum, ange alla projekttyper och slutsumma J. Jämför lager aconto med saldot på kontot i bokföringen. Glöm inte att summera alla underkonton, dvs 242001, 242002 osv. |
||
| − | |||
| − | '''Vid differens:''' |
||
| − | |||
| − | * Kontrollera bokningarna på aconto-kontot i {{pth|Ekonomi|Rapporter}}, Kontospecifikation för att se att inga manuella ombokningar är gjorda under perioden. |
||
| − | |||
| − | '''Avstämning lagerkonto inköp ''' |
||
| − | |||
| − | Inköp i Marathon kan antingen kostnadsföras direkt vid registrering av faktura, eller konteras på ett lagerkonto och kostnadsföras först vid utskrift av faktura till kund. |
||
| − | For att undvika differens mellan lagerkontot och lagret i projektredovisningen, ska inga manuella bokningar registreras på lagerkontot och inga inköp ska registreras direkt i projektredovisningen. |
||
| − | |||
| − | '''Avstämning:''' |
||
| − | |||
| − | * Se till att alla inköp är uppdaterade för den aktuella perioden i {{pth|Projekt| Registrering, korrigering och uppdatering}}. |
||
| − | |||
| − | * Se till att UB för föregående år stämmer med IB för innevarande år. |
||
| − | |||
| − | *Ta ut rapport Lagerlista bokföringsperiod i {{pth|Projekt|Rapporter}} och selektera på den period som ska stämmas av. Jämför totalsumman för Inköp Inpris med saldot på lagerkontot i {{pth|Ekonomi|Frågor}} flik Konton alternativt ta ut en Kontospecifikation/huvudbok under Rapporter flik Bokföring. |
||
| − | |||
| − | '''Vid differens''' |
||
| − | |||
| − | * Kontrollera att alla inköpskoder har kostnadskonton i {{pth|System|Basregister/Pro/Kostnadskoder → Inköp}}. |
||
| − | |||
| − | * Kontrollera verifikationerna på lagerkontot i {{pth|Ekonomi|Rapporter}}, Kontospecifikation så att inga manuella bokningar är gjorda under perioden. |
||
| − | |||
| − | * Om en faktura vänds efter omläggning till lagerkonto så måste kostnaden konteras om manuellt. |
||
| − | |||
| − | '''Avstämning fakturerat ''' |
||
| − | |||
| − | * Kör rapport Avstämning PRO/MED under Ekonomi/Rapporter flik Bokföring för perioden. Vid differens, öppna raden och kontrollera fakturor som differensen avser. Differensen beror nästan alltid på att man manuellt har korrigerat fakturan under Verifikationer. |
||
| − | |||
| − | Alternativt: |
||
| − | *Stäm av fakturerat utpris i projektredovisningen (använd lämplig rapport) mot de intäktskonton i bokföringen som används vid faktureringen. Vilka dessa är kan man se på kostnadskoderna i System/Basregister/Pro/Kostnadkoder. Glöm inte att stämma av alla intäktskonton med momskontoändelse 01 (moms inrikes), 02 (momsfritt inrikes), 03 (utanför EU), och 04 (inom EU). |
||
| − | |||
| − | '''Vid differens''' |
||
| − | *Kontrollera att inga manuella bokningar har gjorts på intäktskontona. |
||
| − | |||
| − | på alla verifikationstyper förutom den för kundfaktura. |
||
| − | |||
| − | * Kontrollera att rapporten du stämmer av mot verkligen visar allt som är fakturerat i projektredovisningen (fakturerat utpris på arvode, inköp och övrigt). |
||
| − | |||
| − | [[Category:avs-avs-sv]] |
||
| − | [[Category:Manuals]] |
||
| − | [[Category:Accounting]] |
||
Revision as of 15:13, 11 February 2026
Monthly closing and reconciliations
Monthly closing
Bookkeeping
- Update periodical allocations in Accounting | Backoffice | Periodical allocations, the Update periodical allocations tab.
- Print the Reconciliation periodical allocations in Accounting | Reports, General ledger tab and compare with the balance on the account for periodical allocations. Read further under Reconciliation Periodical allocations.
- Print VAT declaration under Accounting | Reports, General ledger tab. See separate chapter about VAT reconciliation.
Sales ledger
- Check balances on the Trade debtor's accounts and compare with balance report in Accounting | Reports, Sales ledger tab. Read more under Reconciliation Sales ledger.
- Print Payment reminders in Accounting | Client invoices, Reminders tab. Reminders for single invoices is easily made in the Queries tab. Search the invoice and press the Payment reminders button.
- Interest invoicing is made in Accounting | Client invoices, Interest invoices tab.
Purchase ledger
- Check balances on the Trade creditor’s accounts and compare with balance report in Accounting | Reports, Purchase ledger tab. Read more under Reconciliation Purchase ledger.
Project accounting
- Check that everybody has reported their hours Use the report Reconciliation time.
- Register project related costs, book supplier invoices and expense reports.
- Update hours and purchases in Projects | Backoffice | Transactions, Update WIP tab. Adjust and invoice. Close finished projects.
- Zero invoice in Projects | Invoicing, Zero invoicing tab (especially if you use balance sheet account for project purchases).
- Print out WIP list accounting period in Projects | Reports and compare un-deducted pre-invoice (read more in chapter Reconciliation Pre-invoice) and purchase price WIP for purchases with the WIP account for purchases (if it is in use, read more in Reconciliation WIP account purchases).
- Compare invoiced in the project accounting with the revenue accounts in the bookkeeping that are used in the invoicing. Read more in Reconciliation Invoiced.
- Print project reports in Projects | Reports
Reconciliation
Periodical allocations
Reconciliation:
- Update periodical allocations in Accounting | Backoffice | Periodical allocations, tab Update periodical allocations.
- Reconcile the allocations in Accounting | Reports, General ledger tab. The report is called Reconciliation Periodical allocations. Make a selection of the future allocations that are booked to the last date in that period.
- Example: Period 010725-blank and Accounting date blank -300625. Tick in Print out updated. Compare the amount of the list with the account for automatic periodical allocations. You can see its balance in e.g. Accounting | Queries, Accounts tab or in Accounting | Reports, General ledger tab.
In case of discrepancy:
- Print the report Reconciliation periodical allocations without selection on period or accounting dates. Make sure that the option Print updated not is ticked. Then you see all allocations that wait for update; there might be unupdated allocations in previous periods to catch up.
- Check the account for periodical allocations in Accounting | Queries, Accounts tab, or in Accounting | Reports, General ledger tab, Account specification. Check in the column Type if there have been bookings without assignment code.
VAT
Marathon keeps track of VAT- liable revenue, VAT-exempt revenue and foreign export with subaccounts.
XXXX01 – VAT-liable domestic
XXXX02 – VAT-exempt domestic
XXXX03 – outside the EU
XXXX04 – within the EU
It is important to keep to Marathon’s structure, to avoid discrepancies. The system is not capable of interpreting and placing bookings on accounts without subaccounts on the VAT declaration. The VAT declaration in Accounting | Reports, General ledger tab, requires that the VAT is booked away with a reconciliation account each month. It is recommended that the previous month’s VAT is booked away in the beginning of the following month. That way you can see the VAT history.
Reconciliation
- Make a control count of the VAT declaration for the period.
In case of discrepancy:
- Make sure that the VAT for previous month is booked away. There might be new transactions after the declaration, which means that the VAT amount this month might be higher.
- Print out list VAT reconciliation in Accounting | Reports, General ledger tab and make a selection on Period. Here you can see all entries without “correct” Vat booked.
- Look through the VAT account in the Account specification to see that no manual rebookings have been made (except the VAT). The specification is in Accounting | Reports, General ledger tab.
Sales ledger
Reconciliation
- Print out balance list per reconciliation date in Accounting | Reports, Sales ledger tab. Check the total amount and compare with the balance on the trade debtor’s account.
In case of discrepancy:
- Print out the list Reconciliation to GL in Accounting | Reports, Sales ledger tab to see what day the discrepancy occurred.
- Print the list again and select only on the day that the discrepancy occurred, untick the box “Only Summary”.
- Check the bookings in the account specification in Accounting | Reports, General ledger tab and check if there are any bookings that lack assignment code in the Type column.
- Finally check all invoices in the sales ledger and compare with the invoice amount in the bookkeeping.
Purchase ledger
Reconciliation:
- Print out balance list in Accounting | Reports, Purchase ledger tab. Check the total amount and compare with the balance on the trade creditor’s account.
In case of discrepancy:
- Print out the list Reconciliation to GL in Accounting | Reports, Purchase ledger tab to see what day the discrepancy occurred.
- Print the list again and select only on the day that the discrepancy occurred, untick the box “Only Summary”.
- Check the bookings in the account specification in Accounting | Reports, General ledger tab and check if there are any bookings that lack assignment code in the Type column.
- Finally check all invoices in the purchase ledger and compare with the invoice amount in the bookkeeping.
Project accounting
Pre-invoice
Reconciliation
- Print out WIP list Accounting period per reconciliation date in Projects | Reports. Enter all project types and tick the box Totals only. Compare WIP pre-invoiced with the account balance in the bookkeeping. Remember to summarize all subaccounts, i.e. 242001, 242002 etc.
In case of discrepancy:
- Check the bookings on the account for pre-invoice in the Account specification in Accounting | Reports, General ledger tab. There might be manual bookings during the period.
WIP account purchases
Purchases in Marathon can either be expensed directly when the invoice is registered or be posted on a WIP account and expensed when invoicing the client. To avoid discrepancy between the WIP account and the WIP in project accounting, no manual bookings should be registered on the WIP account, and no purchases should be registered directly in the project accounting. Reconciliation:
- Make sure that all purchases are updated for the period in Projects | Backoffice | Transactions, Update WIP tab.
- Print WIP list accounting period in Projects | Reports per reconciliation date. Compare the total amount for purchases purchase price with the balance on the WIP account in Accounting | Queries, Accounts tab. Alternatively, print an account statement in Accounting | Reports, General ledger tab.
In case of discrepancy
- Check that all purchase codes have expenses accounts in Projects | Backoffice | Base registers.
- Check the vouchers on the WIP account in Accounting | Queries or in the account specification in Accounting | Reports, General ledger tab. There might be manual bookings made during the period.
- Check that Closing balance for the previous year agrees with current year’s Opening balance in the bookkeeping.
- If an invoice is reversed after being transferred ti WIP account, the expense must be re-posted manually.
Invoiced
- Print out Reconciliation PRO | MED for the period in Accounting | Reports, General ledger tab. If there is a discrepancy, open the row and check the invoiced with discrepancy. The reason for the discrepancy is almost always that an invoice has been manually corrected in Vouchers.
- You can also print the report Printout invoice list in Projects | Reports and compare with the revenue accounts in the bookkeeping that are used in the invoicing. You can see the accounts on the cost codes in Projects | Backoffice | Base registers. Remember to reconcile all revenue accounts with VAR account suffixes 01 (domestic VAT), 02 (domestic VAT-exempt), 03 (outside EU), and 04 (within EU).
In case of discrepancy
- Check possible manual bookings on the revenue accounts on all voucher types, except for client invoice.
