Important Notes and instructions for Integrating Between Hinawi ERP with QuickBooks
1. Before you start, change the type of account in the Hinawi ERP chart regarding Cash Type, PDC, and CUC Account type.
2. All users of Hinawi ERP must have used an m e in QuickBooks and permissions too.
3. If you have already created a QuickBooks data file and now you want to use Hinawi ERP Software, the following points must be checked in the QuickBooks file before start using our software: -
- Make sure that preference is done properly and completed.
- Make sure you did allocations between payments to suppliers and bills, the report.
- Unpaid bills Detail under Vendors and Payables Report should not show any negative amount.
- Same for the report Open Invoices under Customers and Receivables should not have negative amounts.
4. The users in QuickBooks must have Full Permission to access the activity forms they used in Hinawi ER. For Example:
- Creating new Transaction in Hinawi ERP: -
The user mu s t h a v e p er mis sio n in QuickBooks to Create a Transaction for that Transaction (Form Activity).
- For Editing Transaction in Hinawi ERP: -
The user must have permission in QuickBooks to Create, Modify & Delete the Transaction. This is an important point; if no permission is specified above, the transaction will duplicate in QuickBooks.
- If t h e user makes an "Edit" write a check and his Setup is "Automatic," the system will delete the original transaction and create the same automatically. To avoid deleting, set a closing date in QB every month.
5. Do not Merge or delete Accounts in the Chart of Account list, vendors, customers, or employees in QuickBooks.
6. Do not convert the names in the `Other Names` list in QuickBooks to the Vendors or Customers or Employees List.
7. To switch between multiple Accounting files in QuickBooks. First, you must close Hinawi ERP and then open the QuickBooks file.
8. By editing transactions in Hinawi ERP, QuickBooks will delete the original one and create a new one. If this transaction is before the set closing dates, QuickBooks will not allow editing in Hinawi ERP. To avoid deleting, set a closing date in QuickBooks every month.
9. Make sure to close all kinds of windows in QuickBooks that affect running integration, e.g., Windows of, Videos, preferences, set closing date, setup users, Company information, Add \ Edit Multiple Entries, Verify, Rebuild or clean data and any online QuickBooks services window that opened from QuickBooks or Set Credit` window in Accounts Receivables and Payables. And QuickBooks does not open company information under the company menu during integration or posting.
10. If the User enters the Transaction through Hinawi ERP and later modifies the same Transaction from QuickBooks, it will not affect Hinawi ER So, the user must do ALL his work from Hinawi to guarantee a match of balances.
11. Hinawi ERP does not read Multi-Currency from QuickBooks. Still, when creating a transaction in Hinawi ERP, it will automatically read the currency in QuickBooks, except for the Journal Voucher, where the user must select the currency of each transaction.
12. We recommend Admin user does 'closing of data' in QuickBooks at the end of each month. By this, no transactions can be entered or edited from Hinawi ERP.
13. Ensure the person in charge is the only one to use the Admin user. Do not give the password to another user
14. Do not give Admin passwords to normal users.
15. The date setup in all computers and servers is dd/mm/yyyy. Example: 31/12/2021
16. If you want to run software in Arabic, filling in ALL required fields in Arabic is very important. Missing Arabic fields are located under the File menu.
17. Keep data updated to avoid missing information in reports or activities. The Missing data report is located under the File menu.
Important:
All Setup done by the customer is his FULL responsibility.
Settings: -
Complete all settings
Templates
Complete all Templates
Chart of Account Type
Integration Settings:
Make sure to select the integration method that meets your needs.
Sample of process if select manual posting:
Users must update QuickBooks in the below way. In Automatic Setup, all transactions will be posted to QuickBooks automatically.
Attachment Setup:
Make sure is done to save all types of attachments
Things to do in QuickBooks before and during using Hinawi ERP: -
If the customer already has QuickBooks data, the user must work in the below for better use of both QuickBooks and Hinawi ERP
1. Make sure there are no Arabic names in all lists
2. Merge similar names in all lists
3. Create an Account in Chart of Account no. 99 Intermediate Account
4. Make sure that Account no. 30000 opening Balance is created
5. Delete unnecessary names
6. Make sure that preference is done properly and completed.
7. Make sure you made allocations between payments to suppliers and bills; the report Unpaid bi tells Detail under Vendors, and Payables Report should not show any negative amounts.
8. Same for report Open Inv voices under Customers and R receive ables should not have negative amounts.
9. Rearrange the accounts of Fixed Asset
10. Import Fixed Assets
11. Rearrange the accounts of Cheques under Collections (CUC) and Post Dated Cheques (PDC). Edit account type in hinawi Chart of Account to PDC or CUC type
12. Set a closing date
13. Set Preferences
Extra features from Hinawi ERP Software that I s not available in QuickBooks:
1. Fully integrated with all versions of QuickBooks.
2. Cover missing features in QuickBooks.
3. Real Estate Management Modul
4. Advanced Fixed Assets Modul
5. Complete Bilingual Language, Arabic, and English.
6. Calculate Commission for sales Re
7. Post multiple Receivables and Payables in one JV entry.
8. Create Receipt Vouchers (RV) from all kinds of na
9. Adding three new types in the Chart of Accounts (Cash, PDC & CUC).
10. Create three ways to post to QuickBooks. Real-Time, Batches, and Mix of two.
11. Control Post Dated Cheques Received & Issued with auto-revised entry.
12. Receive multiple cheques at one Receipt Voucher (RV).
13. Option to Not allow to post to the main Account
14. Option not to sell if there is not enough quantity
15. Option not to change the selling price
16. Allocate expenses to Fixed A
17. Photos of all kinds of na
18. Design and templates with Printing for all activity forms (Cheques, Payments, Collections, JV, SIV, SRV, Transfer Inventory, Inventory Adjustments, Enter Bill & more)
19. Complete the HR, Time Sheet, Payroll, WPS, and Tax Module.
Inventory:
1. Calculate the Landed Cost of the Inventory Item (Adding Shipping charges, customs, transportation, and Other expenses).
2. Multiple Inventory Adjustment entries in one form.
3. Movement and None Movement Inventory Item.
4. Advanced Physical Inventory Worksheet.
5. New look at Inventory Valuation Detail.
6. And more.
Reports:
1. Advanced Trial Balance (Beginning Balance, total movements, and Ending Balance).
2. Financial Ratios: Profitability, Activity & Liquidity.
3. Advanced Customer / Job profitability report in summary and detail.
4. Cashier Reports (Collections & Payments).
5. Advanced Audit Trail (Filter By user, activity form, and total entries by each).
6. Partial paid Invoices and Bi
7. Depreciation by Project.
8. You Can customize your required reports from QuickBooks data.
9. Reports in QuickBooks are seen from Hinawi ERP.
Report Center by:
1. Employee
2. Building and flat
3. Class
4. Fixed A
5. And more
العربية
