Difference between revisions of "Monthly closing reconciliation/nb"
From Marathon Documentation
(Updating to match new version of source page) |
(Updating to match new version of source page) |
||
| (100 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
__FORCETOC__ |
__FORCETOC__ |
||
| + | = Monthly closing and reconciliations= |
||
| + | == Monthly closing == |
||
| − | <div class="mw-translate-fuzzy"> |
||
| + | === Bookkeeping === |
||
| − | == Månedsavslutt og avstemminger == |
||
| + | * Update periodical allocations in Accounting | Backoffice | Periodical allocations, the Update periodical allocations tab. |
||
| − | </div> |
||
| + | * 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:''' |
||
| − | <div class="mw-translate-fuzzy"> |
||
| + | * 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. |
||
| − | === Bokføring === |
||
| + | * 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. |
||
| − | </div> |
||
| + | === VAT === |
||
| − | * Oppdater periodiseringer i Classic 01-41. |
||
| + | Marathon keeps track of VAT- liable revenue, VAT-exempt revenue and foreign export with subaccounts. |
||
| + | XXXX01 – VAT-liable domestic |
||
| − | <div class="mw-translate-fuzzy"> |
||
| − | * Avstem periodiseringer i Classic 01-62 mot saldo på periodiseringskontoen. Se videre under Avstemming periodiseringer. |
||
| − | </div> |
||
| + | XXXX02 – VAT-exempt domestic |
||
| − | * Mva.rapporter utskrives i Classic 01-65-01, 01-65-02, 01-65-04. Se separat avsnitt for Mva.- avstemming. |
||
| + | XXXX03 – outside the EU |
||
| − | * Balanse- og resultatregning utskrives i Classic 01-70 eller i {{pth|Økonomi|Rapporter}}, Balansrækning/Resultatrækning |
||
| + | XXXX04 – within the EU |
||
| − | '''Kundereskontro''' |
||
| + | 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. |
||
| − | * Avstem saldo på kundefordringskontoen mot saldoliste i Classic 02-70 alternativt mot saldolisten under {{pth|Økonomi|Spørsmål/Kundereskontro}}.Se videre under Avstemming kundereskontroen. |
||
| + | 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 Classic 02-61. |
||
| + | * 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=== |
||
| − | * Rentefakturering lages i Classic 02-62. |
||
| + | 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=== |
||
| − | '''Leverandørsreskontro''' |
||
| + | '''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:''' |
||
| − | * Avstem saldo på leverandørsgjeldskontoen mot saldolista i Classic 03-70 alternativt mot saldolisten under {{pth|Økonomi/Spørsmål/Leverandørsreskontro}}. Se videre under Avstemming leverandørsreskontroen |
||
| + | * 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. |
||
| − | '''Prosjektregnskap''' |
||
| + | [[Category:avs-avs-en]] [[Category:Manuals]] [[Category:Accounting]] |
||
| − | <div class="mw-translate-fuzzy"> |
||
| − | * Kontroller at alle har rapportert timene sine i {{pth|Prosjekter|Rapporter}}Avstemming tid. |
||
| − | </div> |
||
| − | |||
| − | * Registrer inn prosjektrelaterte kostnader, bokfør leverandørsfakturaer og utlegg. |
||
| − | |||
| − | <div class="mw-translate-fuzzy"> |
||
| − | * Oppdater timer og innkjøp i {{pth|Prosjekt|Registrering, korrigering og oppdatering}}. |
||
| − | </div> |
||
| − | |||
| − | * Juster og fakturer. Lukk avsluttede prosjekter. |
||
| − | |||
| − | * Nullfakturer i 04-41-80. |
||
| − | |||
| − | * Skriv ut lagerlista i Classic 04-71-03 og avstem uavregnet akonto (se videre under Avstemming akonto) og innprislagret for innkjøp mot lagerkontoen for innkjøp (dersom det anvendes), se videre under Avstemming lagerkonto innkjøp. |
||
| − | |||
| − | * Avstem fakturert i prosjektregnskapen mot de inntekstkontoer som anvendes ved faktureringen. Se videre under Avstemming fakturert. |
||
| − | |||
| − | <div class="mw-translate-fuzzy"> |
||
| − | * Prosjektrapporter utskrives under {{pth|Prosjekter| Rapporter}}. |
||
| − | </div> |
||
| − | |||
| − | <div class="mw-translate-fuzzy"> |
||
| − | === Avstemming periodiseringer === |
||
| − | </div> |
||
| − | |||
| − | '''Slik gjør du ved avstemming:''' |
||
| − | |||
| − | * Oppdater periodiseringer i program 01-41. Avstem periodiseringene i 01-62 ved å selektere på de periodiseringer som ligger framåt i tiden og som er bokførte per den siste datoen i den aktuelle perioden, for eksempel periode 1406-9999 og bokføringsdato 000000-140531. Sett J på Skriv ut oppdaterte. Beløpet på listen avstemmes med kontoen for automatiske periodiseringer. |
||
| − | |||
| − | '''Ved differanse:''' |
||
| − | |||
| − | * Begynn med å titte i 01-99-03. Her ligger alle periodiseringer som ikke er oppdaterte og melding om eventuelle feil på en periodisering. |
||
| − | |||
| − | * Kontroller i {{pth|Økonomi| Rapporter}},Kontospesifikasjon for å se dersom bokføringer er gjorte uten integrasjonsko |
||
| − | |||
| − | <div class="mw-translate-fuzzy"> |
||
| − | === Mva. – avstemming === |
||
| − | </div> |
||
| − | |||
| − | Marathon anvender underkontoer for å holde rede på mva –pliktig inntekt, mva –fri inntekt og eksport utenfor landet: |
||
| − | |||
| − | XXXX01 – mva -pliktig innenfor landet |
||
| − | |||
| − | XXXX02 – mva –fri innenfor landet |
||
| − | |||
| − | XXXX03 – utenfor EU |
||
| − | |||
| − | XXXX04 – innenfor EU |
||
| − | |||
| − | For å unngå differanse er det viktig å følge Marathon sin struktur. Systemet kan ikke tolke å plassere bookinger på kontoer i mva –deklarasjonen uten rette underkontoer. |
||
| − | |||
| − | Mva – deklarasjonen i 01-65 forutsetter at mva. overstyres hver måned. For å kunne se mva tilbake i tida anbefales at mva for forrige måned overstyres i begynnelsen av neste måned. |
||
| − | |||
| − | <div class="mw-translate-fuzzy"> |
||
| − | === Gjør følgende ved avstemming === |
||
| − | </div> |
||
| − | |||
| − | * Kontrollregn mva – deklarasjonen din i 01-65-01 for den aktuelle perioden. |
||
| − | |||
| − | '''Ved differanse:''' |
||
| − | |||
| − | * Kontroller at mva for foregående måned er overstyrt. Eventuell kan det ha innkommet transaksjoner etter at deklarasjonen ble gjort, hvilket betyr at mva –beløpet denne måned blir høyere. |
||
| − | |||
| − | * Skriv ut listen 01-90-02 og selekter på den periode du vil avstemme. |
||
| − | Her viser systemet de poster, som ikke har ”rett” mva oppgitt. |
||
| − | |||
| − | * Kontroller at det ikke er gjort bookinger på en firesifret inntektskonto. |
||
| − | |||
| − | * Titt igjennom mva –kontoen i {{pth|Økonomi|Rapporter}}, Kontospesifikasjon for den valgte perioden slik at ingen manuelle gjenbookinger er blitt gjorte (foruten gjenbookingen av mva) . |
||
| − | |||
| − | <div class="mw-translate-fuzzy"> |
||
| − | === Avstemming kundereskontroen === |
||
| − | </div> |
||
| − | |||
| − | '''Gjør følgende ved avstemming:''' |
||
| − | |||
| − | <div class="mw-translate-fuzzy"> |
||
| − | * Skriv ut saldoliste i 02-70 pr. avstemmingsdato. Kontroller det totale beløpet og sammenlign med saldoen på kundefordringskontoen. |
||
| − | </div> |
||
| − | |||
| − | '''Ved differanse:''' |
||
| − | |||
| − | * Skriv ut listen 02-72 for å se hvilken dato differansen har oppstått. |
||
| − | |||
| − | * Skriv ut listen 02-72 på nytt og selekter bare pr. den dato som differansen oppsto, og velg ”Bare sammendrag" =N. |
||
| − | |||
| − | * Dersom differansen oppsto på grunn av en betaling med bilagsnummer BO000001 beror det formentlig på at 02-60 har blitt brukt til å registrere en betaling. Da bookes betalingen bare i kundereskontroen og ikke i bokføringen. Legg i så fall tilbake betalingen i 02-60 med motsatt tegn. |
||
| − | |||
| − | * Avslutt med å sammenligne hver faktura i kundereskontroen med fakturabeløpet i bokføringen, for å utelukke at endringer er gjort på faktura som siden lagrets uten kontering i 02-30. Endringen skjer da ikke i bokføringen. Legg i så fall tilbake endringen og oppdater uten kontering på nytt. Endr på nytt og lagr med kontering (funksjon1). |
||
| − | |||
| − | <div class="mw-translate-fuzzy"> |
||
| − | === Avstemming Leverandørreskontroen === |
||
| − | </div> |
||
| − | |||
| − | '''Gjør følgende ved avstemming:''' |
||
| − | |||
| − | * Skriv ut liste 03-70 pr avstemmingsdato. Noter det totale beløpet og sammenlign med saldoen på leverandørsgjeldskontoen. |
||
| − | |||
| − | Ved differanse: |
||
| − | |||
| − | * Skriv ut listen 03-72 for å se hvilken dato differansen har oppstått. |
||
| − | |||
| − | *Skriv ut listen 03-72 på nytt og selekter bare pr. den dato som differansen oppsto, og velg ”Bare sammendrag" =N. |
||
| − | |||
| − | * Kontroller i {{pth|Økonomi|Rapporter}}, Kontospesifikasjon på datoen for differansen for å se dersom der har bookets noe uten integrasjonskode. |
||
| − | |||
| − | * Avslutt med å sammenligne hver faktura i leverandørreskontroen med fakturabeløpet i bokføringen, for å utelukke at endringer er gjort på faktura som siden lagrets uten kontering i 03-32. Endringen skjer da ikke i bokføringen. Legg i så fall tilbake endringen og oppdater uten kontering på nytt. Endr på nytt og lagr med kontering (funksjon1). |
||
| − | |||
| − | <div class="mw-translate-fuzzy"> |
||
| − | === Avstemming prosjektregnskapen === |
||
| − | </div> |
||
| − | |||
| − | '''Avstemming akonto''' |
||
| − | |||
| − | '''Gjør følgende ved avstemming:''' |
||
| − | |||
| − | * Skriv ut listen 04-71-03 og selekter på den periode som skal avstemmes og sammenlign innkjøp innpris med saldoen på lagerkontoen i {{pth|Økonomi|Rapporter}},Kontospesifikasjon. Angi alle prosjektsorter og Kun Sluttsum = J. |
||
| − | |||
| − | '''Ved differanse:''' |
||
| − | |||
| − | * Kontroller bookingene på kontoen for akonto i {{pth|Økonomi|Rapporter}}, Kontospesifikasjon for å se at der ikke ligger manuelle gjenbookinger gjorte under perioden. |
||
| − | |||
| − | '''Avstemming av lagerkonto innkjøp ''' |
||
| − | |||
| − | Innkjøp i Marathon kan enten kostnadsfores direkte ved registrering av faktura, eller konteres på et lagerkonto og kostnadsfores ved utskrift av kundefakturaen. For å unngå differanse mellom lagerkontoen og prosjektregnskapen bør ingen manuelle bookinger registreres på lagerkontoen og helle ringen innkjøp må registreres direkte i prosjektregnskapen. |
||
| − | |||
| − | '''Gjør følgende ved avstemming:''' |
||
| − | |||
| − | * Se til at alle innkjøp er oppdaterte for den aktuelle perioden i {{pth|Prosjekter| Registrering, korrigering og oppdatering}}. |
||
| − | |||
| − | *Se til at UB for foregående år stemmer overens med IB for inneværende år. |
||
| − | |||
| − | *Skriv ut listen 04-71-03 og selekter på den periode som skal avstemmes og sammenlign innkjøp innpris med saldoen på lagerkontoen i {{pth|Økonomi| Rapporter}},Kontospesifikasjon. Angi alle prosjektsorter og Kun Sluttsum = J. |
||
| − | |||
| − | '''Ved differanse''' |
||
| − | |||
| − | *Kjør program 04-99-31 for å se hvis du direkte kan se hvilken/hvilke innkjøp som er feil . |
||
| − | |||
| − | * Kontroller at ingen innkjøpskoder mangler kostnadskontoer i {{pth|System|Grunnregister/ PRO/Innkjøpskoder}}. |
||
| − | |||
| − | * Kontroller bilagene på lagerkontoen i {{pth|Økonomi| Rapporter}}, Kontospesifikasjon slik at ingen manuelle bookinger er gjort under perioden. |
||
| − | |||
| − | * Dersom en faktura krediteres etter omlegging til lagerkonto, må kostnaden gjenkonteres manuelt. |
||
| − | |||
| − | '''Avstemming fakturert ''' |
||
| − | |||
| − | <div class="mw-translate-fuzzy"> |
||
| − | * Avstem fakturert utpris i prosjektregnskapet (bruk passende rapport) mot de inntekstkontoer i bokføringen som brukes ved fakturering. Du kan se hvilke de er i kostnadskodene i {{pth|System|Grunnregister/Pro/Kostnadkoder}}. Ikke glem avstemming av inntektskontoer med mva.-kontoendelsene 01 (innenriks mva), 02 (innenriks mva-fri), 03 (utenfor EU), og 04 (EU). |
||
| − | |||
| − | '''Ved differanse''' |
||
| − | </div> |
||
| − | |||
| − | * Kontroller at alle kostnadskoder I {{pth|System|Grunnregister/Pro/Kostnadskoder → Honorar har en inntektskonto}}. |
||
| − | |||
| − | * Kontroller at ingen manuelle bookinger er blitt gjorte på inntekstkontoene. |
||
| − | |||
| − | * Kontroller at rapporten du bruker virkelig viser alt fakturert i prosjektregnskapen (fakturert salgspris på honorar, innkjøp og øvrigt) |
||
| − | |||
| − | <div class="mw-translate-fuzzy"> |
||
| − | [[Category:avs-avs-no]] [[Category:Manuals]] [[Category:ACC]] |
||
| − | </div> |
||
Latest 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.
