bank feed and confidential data exposure control via user/roles

bank feed and confidential data exposure control via user/roles

Hi,

We have two bank accounts, with two different purposes. 

  1. Account A to conduct daily operations 
  2. Account B to transfer salaries and tax deducted at source to do with salaries only. There are no other operations on this account.
Monies are transferred from Account A to Account B on a regular basis with Account B functioning as a holding account too. 

Constraint: 
Confidential data such as salaries are not exposed to people working in the accounts department. We are a small organization and from our experience it is best if this data remains with the management and the auditor.

Accounts Assistant Role :
Accounts assistant on a regular basis conducts bank reconciliations, categorizing transactions , raising bills, matching invoices / payments etc. Access to bank feeds is vital especially to conduct day to day operations.

Problem Statement:
  1. How do I provide access to accounts assistant such that it does not give access to salary data?
  2. Right now Account B feeds are not active as there is no control provided at role level to bar access to this account and associated transactions . This creates a wrong view of account balance increasing all the time.
  3. Trial balance are inaccurate as Salary expenses and related tax transactions data are not captured in accounts. 
  4. Let's say we have 10 employees. Currently the Auditor has to enter 10 x 12 months transactions + 10 x 12 x 2 (different type of tax deduction entries) manually in excel sheet .
History of interactions so far with Zoho :
No concrete solution provided so far. Was told to use zoho payroll, which I don't have a problem paying for but then integrating it with zoho books still exposes accounts assistant to all salary entries in zoho books. 

The whole purpose of shifting to zoho from tally to maintain complete accounts seems defeated and main reports in zoho are becoming inaccurate.