Hello, I am working on my Perpetual Inventory Subledger and was wondering if you could put me in the right direction on how you do Perpetual Inventory? Also the Perpetual Inventory that I did here is it right and if its not how do you do Perpetual Inventory Subledger?

This is the Perpetual Inventory Subledger that I did:

This is the Merchandise Inventory Items for March 31, 2018:

Styles Font Clipboard Number Alignment J145 A ABLC LDE Perpetual Inventory Subledger Earphones 6 Inventory Code: 7 Selling Price Ear-1 $25.00 Purchases Sales Inventory Balance Post 9 Date Unit Cost Total Cost Unit Cost Cost of 4 Decimals Goods Sold Ref Units Units Units Unit Cost Cost of Inventory 4 Decimals on hand 3812.5000 475.00 Headphones Ear 2 $40.00 18 Inventory Code 19 Selling Price 20 21 Date Ref 22 April 6 40.00 13 April 24 40.00 Units Units Units Purchases Cost 2 40.00 1 40.00 Cost 80.00 40.00 Sales 4 Decimals Goods Sold 8.0000 80.00 40.00 2 Inventory Balance 4 Decimals on hand 411 20.0000 820.00 41 20.0000 820.00 26 67 Accounts Receivable Subleger Accounts Payable Subleger Perpetual Inventory Subledger Works ... ) X3 J K L M 1145 LA ABC 28 09 30 Inventory Code: 1p-08 31 Selling Price $200.00 32 Purchases IPod 8G with FM Tuner Sales Inventory Balance Post Ref Ref Unit Units to Units Cost Total Cost Unit Cost Cost of 4 Decimals Goods Sold Units Units Unit Cost Cost of Inventory 4 Decimals on hand 100.0000 300.00 100.0000 300.00 1 3 3 100.00 20 100.00 2,000.00 20120.0000 2.000.00 / B3 Date 34 March 31 35 April 3 136 37 38 39 10 / / / / / / Ip-32 IPod 32G with FM Tuner 42 Inventory Code: 43 Selling Price eone Sales Purchases Inventory Balance | Post Ref Unit Cost Total Cost Unit Cost Cost of 4 Decimals Goods Sold Units Units Units #15 Date 16 March 31 17 April 3 18 Unit Cost Cost of Inventory 4 Decimals on hand 125.0000 250.00 125.0000 250.00 125.00 20 125.00 2,500.00 20 25.0000 2 2 2,500.00 149 / X / 150 / / / ... Accounts Receivable Subleger Accounts Payable Subleger Perpetual Inventory Subledger Works ... : Ready J145 DELFI GL Movies - New 64 Inventory Code: 55 Selling Price Mov-New $18.00 Purchases Sales Inventory Balance Cos Post Ref Unit Cost Total Cost Units Unit Cost 4 Decimals Goods Sold 57 Date 58 March 31 69 April 10 LE Unit Cost Cost of Inventory 4 Decimals on hand 359.0000 315.00 359.0000 315.00 16.20 5 16.20 81. 00 5 0.1620 81.00 60 Movies - Previously viewed 56 Inventory Code: 67 Selling Price 58 Mov-Pv $8.00 Purchases Sales Inventory Balance Post Unit Cost Total Cost Unit Cost Cost of 4 Decimals Goods Sold Ref Units Units Units Unit Cost Cost of Inventory 4 Decimals on hand 100 4.0000 400.00 59 Date 70 March 31 11 12 13 1 ... Accounts Receivable Subleger Accounts Payable Subleger Perpetual Inventory Subledger Works ... + Read A B CL DEFG 18 Inventory Code: 19 Selling Price MP3 8G player with FM Tuner MP3-08 $100.00 Purchases Sales Inventory Balance Post Ref Unit Cost Cost of 4 Decimals Goods Sold Units 31 Units 31 Date 32 March 31 33 Unit Cost Cost of Inventory 4 Decimals on hand 3250.0000 1,600.00 34 85 1 MP3 16G with FM Tuner 0 Inventory Code: 91 Selling Price MP3-16 $125.00 Purchases Sales Inventory Balance Total Post Ref Unit Cost OU Unit Cost Cost of 4 Decimals Goods Sold Units Units Unit Cost Cost of Inventory 4 Decimals on hand 62.5000 2,500.00 40 93 Date 14 March 31 05 26 OL - ... Accounts Receivable Subleger Accounts Payable Subleger Perpetual Inventory Subledger Works .... + PSP Player 26 Inventory Code: 27 Selling Price PSP-1 $250.00 Purchases Sales Inventory Balance Post Ref Unit Cost Units Total Cost Unit Cost Cost of 4 Decimals Goods Sold Unit Cost Cost of Inventory 4 Decimals on hand Units Units 29 Date 30 March 31 31 April 3 32 April 10 8 125.00 1 225.00 2,500.00 225.00 25.0000 2.2500 2,500.00 225.00 33 37 Movies - PSP Player 38 Inventory Code: 39 Selling Price 40 Mov-PS $30.00 Purchases Sales Inventory Balance Post Ref Unit Cost Total Cost Unit Cost Cost of 4 Decimals Goods Sold Unit Cost Cost of Inventory 4 Decimals on hand Units Ilnits Units 41 Date 42 March 31 43 April 3 44 April 10 2015.00 227.00 300.00 54.00 20 3 270 .0000 .5400 300.00 54.00 51 46 47 ... Accounts Receivable Subleger Accounts Payable Subleger Perpetual Inventory Subledger Works ... + Red Schedule of Merchandise Inventory Items At March 31, 2018 Item Items Value In stock @ Average Cost Code Item Average Cost Item Description Normal Selling Price Stock $ 25 Ear-1 Ear-2 Earphones Headphones 38 $ 12.5000 41 20.0000 $ 475.00 820.00 IP-08 IP-32 IPod 8G with FM Tuner IPod 32G with FM Tuner 3 2 100.0000 125.0000 300.00 250.00 200 250 Mov-New Mov-Pv Movies - New Movies - Previously viewed 35 100 9.0000 4.0000 315.00 400.00 MP3-08 MP3-16 MP3 8G player with FM Tuner MP3 16G player with FM Tuner 32 40 50.0000 62.5000 1,600.00 2,500.00 100 125 Mus-Ot Mus-Pr Music CDs Other Music CDs Pop/Rock 42 50 7.5000 10.0000 315.00 500.00 Total Inventory at Cost $ 7,475.00 Styles Font Clipboard Number Alignment J145 A ABLC LDE Perpetual Inventory Subledger Earphones 6 Inventory Code: 7 Selling Price Ear-1 $25.00 Purchases Sales Inventory Balance Post 9 Date Unit Cost Total Cost Unit Cost Cost of 4 Decimals Goods Sold Ref Units Units Units Unit Cost Cost of Inventory 4 Decimals on hand 3812.5000 475.00 Headphones Ear 2 $40.00 18 Inventory Code 19 Selling Price 20 21 Date Ref 22 April 6 40.00 13 April 24 40.00 Units Units Units Purchases Cost 2 40.00 1 40.00 Cost 80.00 40.00 Sales 4 Decimals Goods Sold 8.0000 80.00 40.00 2 Inventory Balance 4 Decimals on hand 411 20.0000 820.00 41 20.0000 820.00 26 67 Accounts Receivable Subleger Accounts Payable Subleger Perpetual Inventory Subledger Works ... ) X3 J K L M 1145 LA ABC 28 09 30 Inventory Code: 1p-08 31 Selling Price $200.00 32 Purchases IPod 8G with FM Tuner Sales Inventory Balance Post Ref Ref Unit Units to Units Cost Total Cost Unit Cost Cost of 4 Decimals Goods Sold Units Units Unit Cost Cost of Inventory 4 Decimals on hand 100.0000 300.00 100.0000 300.00 1 3 3 100.00 20 100.00 2,000.00 20120.0000 2.000.00 / B3 Date 34 March 31 35 April 3 136 37 38 39 10 / / / / / / Ip-32 IPod 32G with FM Tuner 42 Inventory Code: 43 Selling Price eone Sales Purchases Inventory Balance | Post Ref Unit Cost Total Cost Unit Cost Cost of 4 Decimals Goods Sold Units Units Units #15 Date 16 March 31 17 April 3 18 Unit Cost Cost of Inventory 4 Decimals on hand 125.0000 250.00 125.0000 250.00 125.00 20 125.00 2,500.00 20 25.0000 2 2 2,500.00 149 / X / 150 / / / ... Accounts Receivable Subleger Accounts Payable Subleger Perpetual Inventory Subledger Works ... : Ready J145 DELFI GL Movies - New 64 Inventory Code: 55 Selling Price Mov-New $18.00 Purchases Sales Inventory Balance Cos Post Ref Unit Cost Total Cost Units Unit Cost 4 Decimals Goods Sold 57 Date 58 March 31 69 April 10 LE Unit Cost Cost of Inventory 4 Decimals on hand 359.0000 315.00 359.0000 315.00 16.20 5 16.20 81. 00 5 0.1620 81.00 60 Movies - Previously viewed 56 Inventory Code: 67 Selling Price 58 Mov-Pv $8.00 Purchases Sales Inventory Balance Post Unit Cost Total Cost Unit Cost Cost of 4 Decimals Goods Sold Ref Units Units Units Unit Cost Cost of Inventory 4 Decimals on hand 100 4.0000 400.00 59 Date 70 March 31 11 12 13 1 ... Accounts Receivable Subleger Accounts Payable Subleger Perpetual Inventory Subledger Works ... + Read A B CL DEFG 18 Inventory Code: 19 Selling Price MP3 8G player with FM Tuner MP3-08 $100.00 Purchases Sales Inventory Balance Post Ref Unit Cost Cost of 4 Decimals Goods Sold Units 31 Units 31 Date 32 March 31 33 Unit Cost Cost of Inventory 4 Decimals on hand 3250.0000 1,600.00 34 85 1 MP3 16G with FM Tuner 0 Inventory Code: 91 Selling Price MP3-16 $125.00 Purchases Sales Inventory Balance Total Post Ref Unit Cost OU Unit Cost Cost of 4 Decimals Goods Sold Units Units Unit Cost Cost of Inventory 4 Decimals on hand 62.5000 2,500.00 40 93 Date 14 March 31 05 26 OL - ... Accounts Receivable Subleger Accounts Payable Subleger Perpetual Inventory Subledger Works .... + PSP Player 26 Inventory Code: 27 Selling Price PSP-1 $250.00 Purchases Sales Inventory Balance Post Ref Unit Cost Units Total Cost Unit Cost Cost of 4 Decimals Goods Sold Unit Cost Cost of Inventory 4 Decimals on hand Units Units 29 Date 30 March 31 31 April 3 32 April 10 8 125.00 1 225.00 2,500.00 225.00 25.0000 2.2500 2,500.00 225.00 33 37 Movies - PSP Player 38 Inventory Code: 39 Selling Price 40 Mov-PS $30.00 Purchases Sales Inventory Balance Post Ref Unit Cost Total Cost Unit Cost Cost of 4 Decimals Goods Sold Unit Cost Cost of Inventory 4 Decimals on hand Units Ilnits Units 41 Date 42 March 31 43 April 3 44 April 10 2015.00 227.00 300.00 54.00 20 3 270 .0000 .5400 300.00 54.00 51 46 47 ... Accounts Receivable Subleger Accounts Payable Subleger Perpetual Inventory Subledger Works ... + Red Schedule of Merchandise Inventory Items At March 31, 2018 Item Items Value In stock @ Average Cost Code Item Average Cost Item Description Normal Selling Price Stock $ 25 Ear-1 Ear-2 Earphones Headphones 38 $ 12.5000 41 20.0000 $ 475.00 820.00 IP-08 IP-32 IPod 8G with FM Tuner IPod 32G with FM Tuner 3 2 100.0000 125.0000 300.00 250.00 200 250 Mov-New Mov-Pv Movies - New Movies - Previously viewed 35 100 9.0000 4.0000 315.00 400.00 MP3-08 MP3-16 MP3 8G player with FM Tuner MP3 16G player with FM Tuner 32 40 50.0000 62.5000 1,600.00 2,500.00 100 125 Mus-Ot Mus-Pr Music CDs Other Music CDs Pop/Rock 42 50 7.5000 10.0000 315.00 500.00 Total Inventory at Cost $ 7,475.00