# **CRUNCHER SYSTEM DOCUMENT** ++More Documents:++ [Cruncher System General - Sheet](https://docs.google.com/spreadsheets/d/1GWzayDK4tKMFilFDEUbwdUFBChZH_mp7Z7STsKPgYdM/edit#gid=211043707) ++Old Documents - MS:++ [User Guide Document | FRMS](/6tNbuWfdQGupKyJQDHFSiw) --- ## :male-office-worker: TEAM MANAGEMENT :::spoiler **Table Summary** |-| SuperAdmin | RegionAdmin | Supervisor | CaseManager | BrandAdmin | BrandManager | |-|-|-|-|-|-|-| |**Belongs to**|- MG <br> - All Brand|- MG <br> -All Brand|- MG <br> - All Brand|- MG <br> - Assigned Brand|- WL - One Brand|- WL - One Brand| |**Description**|- Manager System|-|-|-|- Manager Brand|- Manager clients of Brand| |**Create User**|- Region <br> - Supervior <br> - Case Manager <br> - Brand Admin <br> - Brand Manager <br> - Client|- Supervior <br> - Case Manager <br> - Brand Admin <br> - Brand Manager <br> - Client|- Case Manager <br> - Brand Admin <br> - Brand Manager <br> - Client|- Brand Admin <br> - Brand Manager <br> - Client|- Brand Manager <br> - Client|- Client| ::: ## :bank: BANK ACCOUNT | ACCOUNT NUMBER :::spoiler **Basics - Khái niệm cơ bản** ### Basics - Khái niệm cơ bản Bank Account = Tài khoản ngân hàng Account Number = Số tài khoản Bank Account <---1,n---> Account Number **Bank Name** Account Name A xxxx-last-4-digits Account Number `Account Type` Account Name B xxxx-last-4-digits Account Number `Account Type` :::info ++Sample:++ **ANZ Bank** > Business Number xxxx5678 `Bank` > Premium Saver xxxx1010 `Credit Card` ::: :::spoiler **Add new Bank Account** ### Add new Bank Account > :::warning > Add new Bank Account > ![](https://i.imgur.com/mcZZRfJ.png) > ::: > :::warning > Choose Manual or Online > ![](https://i.imgur.com/P19msQN.png) > ::: > **1. Manual** > :::warning > **Choose Bank** - *Create Bank Account* > ![](https://i.imgur.com/DjrhD45.png) > ::: > :::warning > **Input form Add new Account Number** - *Create Account Number* > ![](https://i.imgur.com/tVCKm1f.png) > ::: > *Started At, IOB : Read more [Financial Report](#FINANCIAL-REPORT)* > **2. Online** > **Open [Iframe Connect Bank](/Y4m1foaxTzKoYUFiwPS2QQ)** - Bank Connection ::: ## :page_with_curl: FINANCIAL REPORT :::spoiler **INIT SETTINGS (STARTED REPORT, IOB)** ### INIT SETTINGS (STARTED REPORT, IOB) **Business:** > Financial Year: > |-|Day|Month|Year| > |-|-|-|- > | :flag-au: |1|7|year| > | :uk: |day|month|year| > | :flag-sg: |-|-|year| > | :flag-vn: |-|-|year| **Account Number:** > **Started At:** Date started Financial Report and HBA for this Account Number > *(Ngày bắt đầu Report và HBA của Account Number này)* > **IOB:** Init Opening Balance - Amount, Date > *(Số dư đầu kì khởi tạo, first OB)* > **Edit IOB** : > :::info > ++Sample:++ > Before Edit IOB: > |-| OB | CB | > |-|-|-| > |Jul 21|0|100| > |Aug 21|100|200| > |Sep 21|200|300| > > After Edit IOB: > - IOB Amount = 150 > - IOB Date = 01 Aug 21 > > |-| OB | CB | > |-|-|-| > |Jul 21|50|150| > |Aug 21|**150**|250| > |Sep 21|250|350| ::: :::spoiler **BU-PU** ### BU-PU (BUDGET USAGE - PRIVATE USAGE) > :::info > **Calculate** > ++Sample:++ > (COA) A MV Fuel : **BU-PU 90%** | $100 > * Private usage - Drawing = $10 > * Budget usage - A MV Fuel = $90 > * A MV Fuel with GST 10% : > * * GST Amount > = $90 - Round($90/(100%+10%), 2) > = $90 - $81.82 > = $8.18 > * * Profit & Loss Amount > = Round($90/(100%+10%), 2) = $81.82 > ::: ### BU-PU Period > :::info > ++Sample:++ > ::: ::: :::spoiler **GENERAL JOURNAL** ### GENERAL JOURNAL **1. Out of Balance** : MUST EQUAL $0.00$ **2. Tax Inclusive** :ballot_box_with_check: > :::info > :ballot_box_with_check: **Tax Inclusive = True** > ++Sample:++ > |Transaction|COA Name|Debit|Credit|Tax| > |-|-|-|-|-:| > |Transaction A|A MV Fuel|110|-|GST (110,0)| > |Transaction B|Sale Income|-|220|GST (220,0)| > |Transaction C|Drawing|110|-|N-T (110,0)| > || > |**Total Debit**|-|-|-|**220**| > |**Total Credit**|-|-|-|**220**| > |**Tax**|-|-|-|~~*-10*~~| > |**Out of balance**|-|-|-|**0**| > ::: > :::info > :black_square_button: **Tax Inclusive = False** > ++Sample:++ > |Transaction|COA Name|Debit|Credit|Tax| > |-|-|-|-|-:| > |Transaction A|A MV Fuel|100|-|GST (100,10)| > |Transaction B|Sale Income|-|200|GST (200,20)| > |Transaction C|Drawing|110|-|N-T (110,0)| > || > |**Total Debit**|-|-|-|**210**| > |**Total Credit**|-|-|-|**200**| > |**Tax**|-|-|-|**-10**| > |**Out of balance**|-|-|-|**0**| > ::: **3. Sale Value, Purchase Value** : Effect to [GST Detail Report](#GST-DETAIL) > :::info > |GJ transaction|BaseType|GST Detail| > |--------------|---------|----------| > |Sale Value|Debit|(-) in Sale, Tax Collected| > |Sale Value|Credit|(+) in Sale, Tax Collected| > |Purchase Value|Debit|(+) in Purchase, Tax Paid| > |Purchase Value|Credit|(-) in Purchase, Tax Paid| > ::: ::: :::spoiler **GST REPORT** ### GST DETAIL ### GST SUMMARY ### GST Period ::: :::spoiler **PROFIT & LOSS REPORT** ### PROFIT & LOSS REPORT ::: :::spoiler **HISTORICAL BALANCING ACCOUNT (HBA)** ### **HISTORICAL BALANCING ACCOUNT (HBA)** ::: :::spoiler **BALANCE SHEET REPORT** ### BALANCE SHEET REPORT ::: :::spoiler **TRIAL BALANCE REPORT** ### TRIAL BALANCE REPORT ::: ## :speech_balloon: CHAT - Client can chat with : > Private : Assigned Case manager, Brand Manager, Brand Admin :radio_button: