Soouk Al-Heli is considering switching from manual to electronic system in automatically registering sales in various accounting books (Daily Sales, General Professor, Associate Professor) due to the company's expansion in opening new branches in the Kingdom of Bahrain and expecting to increase the number of customers. As a specialist in accounting information systems, the company's management asked you to help it convert manual sales on August 25, 2021 into an automated application using Microsoft EXCEL software to be the basis for its support in future sales. The number of the daily sales page (6) the company's sales during September included: Prince's Stores, Wedding Company, and Tower Restaurant Chain The Andalus Hotel and the daily account codes of sales each were 147,146,145,144, respectively, and group codes 801-160. The company adopts triple coding of sales bill numbers with customers. (For the purposes of the solution, the student chooses the appropriate amounts, with the currency box used containing two salaries - for example 215.50 dinars. If you know that the general ledger contains a sales balance of August 24 amounting to 9,500 (from the daily sales figure no. 5) and that the balance of civil collections for the sales of the 5th of August, 24 CR5) is 14,400.40 dinars and the creditor 7,890.50 dinars . The address of the Towers Restaurant Chain can be used ) Pajamas P.P.3245) and customer code (CF-345-1234), and the company markets ornaments had sold to the chain of restaurants towers Goods dated July 28 for 6,450.50 dinars and registered in (SJ5) the customer paid 4500 dinars of which on August 18 and registered in (CR5.( Required: 1. Open separate papers on the same page Microsoft EXCEL program each reflects the part of the required books. 2. Application of all general ledger operations (city and forward sales) and assistant customer ledger for the towers restaurant chain 3. Compliance with the transfer of amounts between different books and the conduct of all calculations and balances using EXCEL Soouk Al-Heli is considering switching from manual to electronic system in automatically registering sales in various accounting books (Daily Sales, General Professor, Associate Professor) due to the company's expansion in opening new branches in the Kingdom of Bahrain and expecting to increase the number of customers. As a specialist in accounting information systems, the company's management asked you to help it convert manual sales on August 25, 2021 into an automated application using Microsoft EXCEL software to be the basis for its support in future sales. The number of the daily sales page (6) the company's sales during September included: Prince's Stores, Wedding Company, and Tower Restaurant Chain The Andalus Hotel and the daily account codes of sales each were 147,146,145,144, respectively, and group codes 801-160. The company adopts triple coding of sales bill numbers with customers. (For the purposes of the solution, the student chooses the appropriate amounts, with the currency box used containing two salaries - for example 215.50 dinars. If you know that the general ledger contains a sales balance of August 24 amounting to 9,500 (from the daily sales figure no. 5) and that the balance of civil collections for the sales of the 5th of August, 24 CR5) is 14,400.40 dinars and the creditor 7,890.50 dinars . The address of the Towers Restaurant Chain can be used ) Pajamas P.P.3245) and customer code (CF-345-1234), and the company markets ornaments had sold to the chain of restaurants towers Goods dated July 28 for 6,450.50 dinars and registered in (SJ5) the customer paid 4500 dinars of which on August 18 and registered in (CR5.( Required: 1. Open separate papers on the same page Microsoft EXCEL program each reflects the part of the required books. 2. Application of all general ledger operations (city and forward sales) and assistant customer ledger for the towers restaurant chain 3. Compliance with the transfer of amounts between different books and the conduct of all calculations and balances using EXCEL
