Accountantjee

  Useful Shortcuts in Google Sheets Use shortcut keys to navigate, format and work with data faster PC Shortcuts Mac Shortcuts Action Navigation [Ctrl] ▼ ⌘ ▼ Move to the bottom of the data region Other arrow keys - move to the edge of the data region [Ctrl] [Shift] ▼ [Shift] ⌘ ▼ Move to the bottom of the data region and highlight the range in between Other arrow key to move & highlight in different direction [Ctrl] A ⌘ A Select data in current region (or all if no data region) [Home] [Fn] ◀ Move to the first cell in the row [Ctrl] [Home] ⌘ [Fn] ◀ Move to cell A1 [End] [Fn] ▶ Move the last cell in the row [Ctrl] [End] ⌘ [Fn] ▶ Move to the last cell in the sheet [Ctrl] [Backspace] ⌘ [Backspace] Show active cell [Tab] Move one cell to the right [Shift] [Tab] Move one cell to the left [Enter] [Enter] Edit mode / move cell down [F2] [F2] Edit cell content [Ctrl] [Shift] [Page ▼] [Option] ▼ Move to the next worksheet [Ctrl] [Shift] [Page ▲] [Option] ▲ Move to the previous worksheet [...

  GSTR-1 is to be furnished by all normal taxpayers on monthly or quarterly basis, as applicable. For Quarterly return filers there is option called IFF- Invoice Furnishing Facility for reporting there outward supplies to registered persons. Earlier While filing GSTR-1 i.e. upto March-2022 GSTR-1 filling we used to follow these below step BEFORE Step 1- Click on “ Generate Summary” button. Step 2- Click on “ Submit” button Step 3- Click on “ Proceed to file ” button to view the final summary before filing. Step 4- Click on “ File Statement” button to file GSTR-1 Step 5- Click on “ File with DSC or EVC” The new changes that has been incorporated in GST portal is mentioned below Removal of Submit Button before filing -  Step 2 has been removed Consolidated Summary-   Taxpayers will now be shown a table wise consolidated summary before actual filing of GSTR-1/IFF. This will provide a complete overview of the records added in GSTR-1/IFF before filing Recipient wise Summary...

  A) How profitable is a company for every $1 in stuff they Sell? 1 How profitable is a company for every dollar they sell of inventory before expense? Cost of Good Sold   = Gross Margin. Revenue 2 How profitable is a company for every dollar they sell of inventory after MOST expense? EBITDA = Operating Margin Revenue 3 How profitable is a company for every dollar they sell of inventory after ALL expense? Net Income = Net Profit Margin Revenue ...