Axxcss Wireless is a 7-company, Big 4 audited, RF ASIC chip designer and manufacturer with global production, locations, and sales. I started off in accounts payable, was promoted to Staff Accountant, then Senior Accountant and was eventually given all responsibilities of the controller who retired. I really enjoyed working through each different level in our accounting department.
Highlights
- Leveraging SQL coding and combining it with my deep understanding of accounting to aggregate data and create 7-company consolidated financial reports from 7 separate databases. This allowed me to create extremely useful and concise financial reports such as rolling 9-quarter reports, inventory cost reports, 7-company consolidated IS/BS/TB/AP/AR etc. SQL allowed me to provide custom financial reports to management, auditors, investors, bankers, and insurance companies and allowed us to pull concise data out of large databases
- SQL reduced the need to keep bloated Excel worksheets and allowed calculations on tables with over 1 million rows (the limit of Excel). SQL also helped to reduce the workload of the IT department by reducing the need to go to them for custom reports. SQL also helped to automate the manual input of data which saved Axxcss money by not having to hire additional employees. SQL coding also helped to defer the need to upgrade to Netsuite because of SQLs ability to consolidate financials from separate databases, saving likely $1 million+ in setup fees, maintenance and additional annual IT salary costs
- Utilized Python coding language to automate document processes and other repetitive tasks - eg. Developed a program that monitored a folder using the Watchdog Observer module until someone dropped a W9 pdf, took that filename, had the program automatically fill out and data a resale certificate form, using PyPDF2 pdf writer, and had it loop through the program for our 4 domestic purchasing companies, creating 4 documents, all with the drop of a file. This saved at least 5 minutes of manual form filling for our purchasing team, per new supplier creation which numbered in the 1,000's
- SQL Budget Analysis (last year vs current spend by GL account or department, last vs current revenue, quarter to quarter results, etc)
- SQL AP/ AR agings, consolidated, used personally and by all upper management for incoming and outgoing cash projections with customized layouts for each executive’s granularity preference
- SQL Trial balance report, used personally and heavily used by CFO and auditors for a clear view of all 7-company's TBs in one concise report
- SQL Cost/ Margin variance report, used to spot orders below margin expectation, especially zero cost error order shipments
- SQL GL account balance reconciliations, used to streamline month and year-end recs and removed the need to enter manually
- SQL GL account lookup report, personally used daily to search all 7 GLs for outages on reconciliations, to check if entries were/ weren't entered, etc. Sidestepping our built in ERP function that would only allow a search of one company at a time where my program allowed me to search through all 7 GLs at once
- SQL Sales Tax report to aggregate and categorize sales (parts, software, repairs, etc) using CASE function to label and the Group By Clause to sum by location, product type (parts, software, warranty, service), and reseller status which automated the sales tax return calculation and reduced time required from 30+ min of manual entry per company using Excel to less than 5 min, this was quarterly x4 companies meaning a lot of time saved
- SQL ACH NACHA and Wire upload bank template reports, used to automate AP, prior to implementing this employees had to manually key in individual payments in the bank which resulted human error typos, the SQL reports removed this room for error while at the same time allowed us to push additional payment information (list of invoices paid) to vendors which reduced the amount of payment application issues
- SQL List of historical transactions (invoices, payments, inventory transactions, first/last 5 receipts) for auditors, this streamlined our audits which reduced billable hour costs
- Percent of sales by country and customer percent of sales over 10% for final financial report footnotes
- SQL Intercompany $0 balance report, used to ensure all intercompany journal entries were entered and intercompany GL accounts were in balance
- Last average part cost, Invoiced products GL account assignment report to verify GL accuracy, on-time payments report, distributor rebate threshold calculation, these are all consolidated 7-company combining results from separate databases with UNIONs, these SQL skills scale with anything dealing with data in a database and are more powerful than using Excel marcos etc
- Cash Management - ensuring each company had enough cash on hand for weekly projected payroll and AP and ensuring spending didn't go over budgeted amount
- Annual Property Tax Filing for our 5 domestic companies
- Fixed asset accounting, including monthly expense JEs, additions, retirements, and transfers using SAGE
- Month/ year-end close account recs
- Insurance accruals and subsequent monthly expense journal entries
- AP accruals and reversals
- Calculating slow moving and obsolete inventory reserve
- Extended warranty accruals and subsequent journal entries to recognize revenue